"Connection is busy with results for another hstmt"

From WebWatchBotWiki
Jump to: navigation, search

SYMPTOMS

In the event viewer, application log, one or more entries with the following description: "Error: -2147467259 Msg: Unspecified error Description: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt Query: SELECT * FROM WatchItemStats WHERE WatchItemId = xxx"


CAUSE

SQL Server is not executing the query requested because it is busy with other queries.


RESOLUTION/WORKAROUND

This issue should be resolved in version 4.0.10 or later, including version 5.0 and later.