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 advance. -- TN
pyodbc: pyodbc-2.1.8-py2.5-linux-x86_64.egg TDS: freetds-0.82 here is the python code: ================== import ePackages import pyodbc import sqlalchemy from sqlalchemy import * import sys, os def pycon(): return pyodbc.connect("DRIVER={FreeTDS};SERVER=myserver;DATABASE=mydatabase;PORT=1435;UID=MYUSER;PWD=MYPASS1") engine = create_engine('mssql://', creator=pycon) metadata = MetaData(bind=engine) result = engine.execute("select * from test_product") for e in result: print e.device Here is the error: ============ Traceback (most recent call last): File "testodbc2.py", line 14, in <module> for e in result: File "/nfs/test/ePackages/sqlalchemy/engine/base.py", line 1548, in __iter__ File "/nfs/test/ePackages/sqlalchemy/engine/base.py", line 1668, in fetchone File "/nfs/test/ePackages/sqlalchemy/engine/base.py", line 931, in _handle_dbapi_exception sqlalchemy.exc.DBAPIError: (Error) ('HY000', 'The driver did not supply an error!') None None Here is the database: =============== Column name Data Type Value device varchar(8) xyz revision varchar(8) ttt process varchar(10) abc created_at datetime 4/26/2011 12:20:00 PM -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.