MS SQL 2005 Native Client ODBC Driver issue - "Connection is busy with another statement"

forum.connectivity (1998-2005) & forum.td.connectivity (2005-2010)
Sankar Vasudevan

MS SQL 2005 Native Client ODBC Driver issue - "Connection is busy with another statement"

Post by Sankar Vasudevan » 17 Nov 2006, 19:03

 Posted by:  Sankar Vasudevan 

Hi,

Please advise if some one is aware of the issue in the subject and could
suggest a work around. Our configuration:

MS SQL Server 2005
Native Client ODBC Driver
Team Developer 2005.1
Error Message: "Connection is busy with another statement"

Scenario: The message above pop-up when we have two active result sets and
are trying to fetch the very first row from the second result set.

Call SqlConnect( hSqlWork1 )
Call SqlConnect( hSqlWork2 )
Call SqlPrepareAndExecute( hSqlWork1, sSql1 )
While SqlFetchNext( hSqlgWork1, ngFetch )
Call SqlPrepareAndExecute( hSqlWork2, sSql2 )
Call SqlFetchNext( hSqlgWork2, ngFetch )
! Eror message pops-up

Thank you in advance.

Regards,
Pavel

Return to “td.connectivity”

Who is online

Users browsing this forum: [Ccbot] and 0 guests