markshiffer
Programmer
I'm getting this error when I am trying to do a series of table opens inside of Delphi, it seems like an ODBC limitation but I'm not sure:<br>
<br>
SQL Error: SQL Server - [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt <br>
<br>
They are just simple "select *" table opens, the first 3 or 4 tables open fine then this error occurs. I've tried using a try..finally but it didn't help. It does not happen every time. <br>
<br>
Any ideas on how to fix this?
<br>
SQL Error: SQL Server - [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt <br>
<br>
They are just simple "select *" table opens, the first 3 or 4 tables open fine then this error occurs. I've tried using a try..finally but it didn't help. It does not happen every time. <br>
<br>
Any ideas on how to fix this?