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