Posted by: Sankar Vasudevan
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.