Connection is busy with results for another hstmt

0 Likes

Problem:

Working on a Microsoft SQL Server database using Acu4GL or AcuSQL, the runtime may encounter an error like this:

"Connection is busy with results for another hstmt"

Resolution:

In AcuSQL, when executing a SELECT using dynamic SQL (i.e. with EXEC SQL PREPARE), the interface didn't know to treat the SQL like a cursor and so other statements on the same connection would fail with the mentioned error.

The same error may occur using Acu4GL for MSSQL.

This issue is now fixed starting with release 9.1.2.1 of extend software.

The fix is developed in ECN-SQL138.

SI: 2546868, 2793950  

Comment List
Related
Recommended