Friday, August 06, 2010

pyodbcs connection strings

Pyodbc conncetion strings gives a useful piece of advice concerning ODBC connection to Excel.
The Excel driver does not support transactions, so you will need to use the autocommit keyword:
cnxn = pyodbc.connect('DSN=test', autocommit=True)

DSN (Data Source Names) are defined in the ODBC data source administrator of the control pannel in windows (in the section administrative tools).

I wasn't able to establish a DSN-less connection.

No comments: