[BangPypers] Django with MSSQL Server 2008

[konark modi]

I have used Python + TEIDD via JDBC, and Python + Microsoft SQL Server
using ODBC..

I'll share my steps with you for connecting ODBC + Python on a linux
machine(CentOS 5.x, 6.x) .

1. Install FREE TDS
2. Install Unix ODBC
3. Install PyODBC
4. Configure the TDS and ODBC settings in $HOME/etc/*.conf
5. Try connecting the sample program.

Pasting installation-script and sample-program on gist.
Installation-script : https://gist.github.com/konarkmodi/6720521
Sample-Program : https://gist.github.com/konarkmodi/6720531

Regards
Konark



On Thu, Sep 26, 2013 at 8:41 PM, Syed Awase khirni <awasekhirni at gmail.com>wrote:

> 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 at python.org
> https://mail.python.org/mailman/listinfo/bangpypers
>