nasihere / pyodbc

Automatically exported from code.google.com/p/pyodbc
MIT No Attribution
0 stars 0 forks source link

Multiple active recordset not working #326

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1.Create a connection object.
2.Create a cursor_1 and fetch result.
3.Before cursor_1 is processed, create another cursor_2 and process it.

What is the expected output? What do you see instead?
Multiple active recordset should be enabled to process multiple cursors.

Error:
DBAPIError: (Error) ('HY000', '[HY000] [Microsoft][ODBC SQL Server 
Driver]Connection is busy with results for another hstmt (0) (SQLExecDirectW)')

What version of the product are you using? On what operating system?
SQLExpress 2012 , Windows 7 Enterprise.

Please provide any additional information below.

I should be able to process multiple cursors with one connection.

Original issue reported on code.google.com by prem1pre on 10 Jun 2013 at 4:42