[ODBC SQL Server Driver]Connection is busy

[dotsavvy]

I am using SQL7 on Win2000. I am writing Perl Application using DBI and DBD-ODBC.

In my program I connect to a SQL7 Database using ODBC.
I execute a SQL Statement and while fetching a row, do another SQL Statement to retrieve other information. I got the following errors:

Execute [Microsoft][ODBC SQL Server Driver]Connection is busy with results for a
nother hstmt (SQL-S1000)(DBD: st_execute/SQLExecute err=-1)

I have no problem with DBD-Oracle. I wonder if this is due to the setup of ODBC for SQL Server to support multiple cursors. Please advise if I need to upgrade and how to upgrade the ODBC driver for SQL Server.

Thanks

 

[foxdev]

I'm not that familiar with the techniques you are using, but it sounds like it is configured to only use one ODBC connection (IOW, to share one ODBC handle). I don't know if you have any control over this within your client.
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[dotsavvy]

I have tried it with Microsoft Access as the database and it work fine ie. multiple cursors.

I was wondering if it could be due to the ODBC drivers for SQL7 on Windows 2K.

Would appreciate if anyone can direct me to get the latest or patch for this.

Thanks