Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2389
  • Last Modified:

SQLSTATE: S1000 Connection busy with the results for another hstmt

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
0
jimmymathai
Asked:
jimmymathai
  • 3
  • 2
1 Solution
 
jimmymathaiAuthor Commented:
ODBC version is 3.52
SQL 2000 Service Pack 2
0
 
i014354Commented:
I'm not sure if this is also relevant to ADO, but check out Microsoft KB article 143032. Summary... Trying to simultaneously execute a second query on the same Connection that currently has an asynchronous query executing will cause the following error:

S1000: [Microsoft][ODBC SQL Server Driver]Connection is busy with
results for another hstmt

CAUSE
After you execute an asynchronous query you cannot access the recordset or execute another asynchronous query on the same rdoConnection until the StillExecuting property of the recordset is False. This behavior is by design.


http://support.microsoft.com/default.aspx?scid=kb;EN-US;q143032
0
 
jimmymathaiAuthor Commented:
thanks for the reference.
For the ADO recordset there is no stillexecuting property.

Can I make the query a synchronous one.
0
 
i014354Commented:
Can you post your code?
0
 
jimmymathaiAuthor Commented:
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
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now