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 <awasekhi...@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@python.org > https://mail.python.org/mailman/listinfo/bangpypers > _______________________________________________ BangPypers mailing list BangPypers@python.org https://mail.python.org/mailman/listinfo/bangpypers
