KBI 310478 “ODBC Error: Connection is busy with results from another hstmt”
Version
Argent XT 8.0A-1104 or above
Date
Thursday, 30 May 2013
Summary
When changing the status of an Alert on Argent Console in Argent Extended Technology (XT) the following ODBC Error Message appears.
ODBC Error: Connection is busy with results from another hstmt
Technical Background
This Microsoft bug is related to backend database connectivity.
It occurs when the ‘SQL Server Driver’ does not function properly with Microsoft SQL Server 2008.
Resolution
To circumvent this Microsoft bug the following can be tried.
Change the SQL connection method as follows:
1. Change the registry key SOFTWARE\Argent\ArgentManagementConsole\SQL_NATIVE_CLIENT from 0 to 2.
2. Restart Argent Console
When the value for SQL_NATIVE_CLIENT is 0 – it uses SQL Server Driver
When the value for SQL_NATIVE_CLIENT is 2 – it uses SQL Server Native Client 10.0