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: 1816
  • Last Modified:

Run-Time error '40002'

My application is built on top of SQL Server 6.5. While trying to access the DB through the GUI, I encountered the following message:
Run-Time error '40002'
S1000:{Microsoft][ODBC SQL Server Driver]Connection is busy with results of another hstmt. Please advise.
0
chuatj
Asked:
chuatj
1 Solution
 
Victor SpiridonovCommented:
What language do you use?
0
 
chuatjAuthor Commented:
The GUI was developed using Visual Basic 5.0 and it communicates with SQL Server through RDO.
0
 
NateTCommented:
If you are running the rdoqueries async then just check the stillexecuting property before executing another query on the same database connection.... Same goes for stored procs.
0
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!

 
chuatjAuthor Commented:
In our application, we used two methods:

1. rdAsynEnable, and we did check the 'stillexecuting' property before executing the next query

2. rdConcurReadOnly, in this case, no checking is needed
 
0
 
chuatjAuthor Commented:
Adjusted points to 100
0
 
manish77Commented:
Try setting the result set to nothing before executing the next query. If you need it then assign it it some other result set .
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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