Why may I get the SQL server error: "HY000 (0):[Microsoft][ODBC sql server Driver] connection is busy with results for other hstmt ".

0 Likes
If you are getting the error:

HY000 (0):[Microsoft][ODBC sql server Driver] connection is busy with results for other hstmt ".


this is informing you that you cannot have multiple active queries running on one connection.

This is not a SilkPerformer generated error, but caused due to the behaviour of the MS SQL Server connection. When a transaction is opened and a table is currently being read in single mode, no other task can be performed within this transaction.

Options to resolve this will be:

  • Close or Fetch all records from the recordset before doing anything else
  • Open a new connection for the second recordset, while the first one is still active.
Comment List
Anonymous
Related Discussions
Recommended