jwv...@gmail.com
unread,Feb 12, 2013, 10:59:53 AM2/12/13Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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]