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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Connection busy

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-09-17 : 21:48:32
Youming writes "HY000 Connection is busy with results for another hstmt.
The SQL Server ODBC driver allows only one active hstmt.
For more information, see Using Default Result Sets.

this is the error i was shown.
The asp page was executing 3-5 insert statement.
Is there anyway to go around it?
Or do i open a new connection?"

   

- Advertisement -