[BangPypers] Django with MSSQL Server 2008

[Syed Awase khirni]

Hello All,

I am a new to Django and i am trying to do some intial bit of learning
myself. I am having difficulty with SQLServer drivers with ADO and pyodbc.
Can any body suggest me exactly the approach. Please find the code in my
settings.py file.

If you could also provide me pointers to downloading the working version of
ADO and pyodbc it will be helpful.

DATABASES = {
    'default': {
        'ENGINE': 'sql_server.pyodbc',  # Have also tried
sql_server.pyodbc,sqlserver_ado',
        'NAME': 'tprone',
        'USER': 'awase', # Omitted for post
        'PASSWORD': '$lny786#', # Omitted for post
        'HOST': 'localhost',
        'PORT': '12345',
        'OPTIONS': {
 #           'provider': 'SQLCLI10', # Have also tried 'SQLCLI11' and
'SQLOLEDB'

             'provider': 'SQLOLEDB',
            'use_mars': True,
            'extra_params': 'DataTypeCompatibility=80'
            }
    }
}

thanks

Awase
_______________________________________________
BangPypers mailing list
BangPypers@python.org
https://mail.python.org/mailman/listinfo/bangpypers