?
Solved

SQLSTATE: S1000 Connection busy with the results for another hstmt

Posted on 2003-03-10
5
Medium Priority
?
2,362 Views
Last Modified: 2013-12-25
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
Comment
Question by:jimmymathai
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 

Author Comment

by:jimmymathai
ID: 8103059
ODBC version is 3.52
SQL 2000 Service Pack 2
0
 
LVL 2

Accepted Solution

by:
i014354 earned 750 total points
ID: 8104086
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
 

Author Comment

by:jimmymathai
ID: 8110710
thanks for the reference.
For the ADO recordset there is no stillexecuting property.

Can I make the query a synchronous one.
0
 
LVL 2

Expert Comment

by:i014354
ID: 8120443
Can you post your code?
0
 

Author Comment

by:jimmymathai
ID: 8172948
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question