thanks Michael. It turns out that pyodbc was compiled with different
version of unixODBC, so there was a mismatch in the libraries used.
After recompiling pyodbc against the intented version of unixODBC,
things seem to work fine.
TPN
On Wed, Apr 27, 2011 at 5:51 PM, Michael Bayer
Hi,
I am getting an error accessing MSSQL database using
sqlalchemy/pyodbc/TDS driver. After narrowing the case, looks like it
has something to do with datetime datatype. If I deldete the
created_at column (datetime) then the same code will work.
Any suggestion for further debugging? Thanks in
that error is generated by TDS/pyodbc and is not related to SQLAlchemy.
Here's your test case with pyodbc alone, the pyodbc or FreeTDS lists might have
further info:
import pyodbc
conn =
pyodbc.connect(DRIVER={FreeTDS};SERVER=myserver;DATABASE=mydatabase;PORT=1435;UID=MYUSER;PWD=MYPASS1)