Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 [Microsoft][ODBC SQL Server Driver] error

Author  Topic 

psangeetha
Yak Posting Veteran

95 Posts

Posted - 2008-05-02 : 13:29:54
Hi everyone,

I am getting the below error when I try to access the table in 2005 database through 3rd party application from the application server.

“[Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt”

This database was restored from sqlserver 2000, so the ODBC connection in the application server first was pointing to 2000 database and now its dropped and recreated to point to the 2005 database.

I dont get this error message when I do the same action from my pc.

I google'd on this error message, and I am not sure if the driver has to be upgraded or if there is anything else that I am missing here.

Thanks much.


rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-03 : 20:50:45
Check blocking on the server.
Go to Top of Page
   

- Advertisement -