<div>
ODBC version is 3.52<br />
SQL 2000 Service Pack 2
</div>


ODBC version is 3.52
SQL 2000 Service Pack 2

<div>
thanks for the reference.<br />
For the ADO recordset there is no stillexecuting property.<br />
<br />
Can I make the query a synchronous one.
</div>


thanks for the reference.
For the ADO recordset there is no stillexecuting property.

Can I make the query a synchronous one.

<div>
It seems to be a bug with ODBC. we changed the design to use ADO directly without the need for ODBC. with that it is working
</div>


It seems to be a bug with ODBC. we changed the design to use ADO directly without the need for ODBC. with that it is working

<div>
<div class="content wysiwyg-content">
I created ODBC DSN for an SQL2000 Database. In VB I am using ADO 2.5. I created a connection object using the dsn with server side cursor. after opening few recordsets using the connection using the .open method further attempt to open a recordset gives the following error<br />
<br />
[Microsoft][ODBC SQL Server Driver]Connection is busy with the results for another hstmt<br />
<br />
It is necessary to use the recordsets in the application. how to handle this error.<br />
<br />
Jimmy
</div>
</div>


I created ODBC DSN for an SQL2000 Database. In VB I am using ADO 2.5. I created a connection object using the dsn with server side cursor. after opening few recordsets using the connection using the .open method further attempt to open a recordset gives the following error

[Microsoft][ODBC SQL Server Driver]Connection is busy with the results for another hstmt

It is necessary to use the recordsets in the application. how to handle this error.

Jimmy

SQLSTATE: S1000 Connection busy with the results for another hstmt

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.