pyodbc + MS Native Driver with multiple connections

56 views
Skip to first unread message

jwv...@gmail.com

unread,
Feb 12, 2013, 10:59:53 AM2/12/13
to pyo...@googlegroups.com, mklee...@gmail.com, mic...@kleehammer.com


pyodbc is awesome but I think I found a flaw in it's use with MS Native Driver.

pyodbc 3.0.6
MS native driver 11
Centos 6.2

pyodbc and the native driver work fine on a single connection but if you create two connections (.connect) you'll get "[SQL Server Native Client 11.0]Connection is busy with results for another command" on any command executed on the second connection,  this applies even if I don't execute any command on the first. I've attached the ODBC log. The log seems to show "[24000] [Microsoft][SQL Server Native Client 11.0]Invalid cursor state" when making the second connection. The issue seems to be at Entry:
                        Statement = 0x1f40a90
[ODBC][11805][1360684068.978679][SQLFetch.c][313]Error: IM001
[ODBC][11805][1360684068.978728][SQLGetTypeInfo.c][168]
odbclog.txt
Reply all
Reply to author
Forward
0 new messages