Running two processes at same time in MSDE

[lagg]

A java program which manipulates data in tables of my access database is throwing the following error "Connection is busy with the results of another hstmt", I understand that is because the process are in competition. How can I resoleve this. I originally had my database in MSAccess before converting over to the MSDE and had no problem with Access

 

[tlbroadbent]

Move to the last row in the result set before attempting any other queries ion the connection. If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[HardcoreTechnoHead]

Alternatively, use second recordset object to return the results of your second query.

something like

objRecordSet.Open "select * from Customer", objConnection, adOpenStatic
do while not objRecordSet.eof
strCustomerId = objRecordSet.Fields("CustomerId&quot.Value
objRecordSet_L2.Open "select * from Site where CustomerId = " & strCustomerId, objConnection, adOpenStatic
do while not objRecordSet_L2.eof
strSiteId = objRecordSet_L2.Fields("SiteId&quot.Value
Print strCustomerId,strSiteId
objRecordSet_L2.MoveNext
loop
objRecordSet.MoveNext
loop

I know this is basic but the logic is the same Andie Harper
"If you can keep your head when all around you have lost theirs, you probably haven't understood the seriousness of the situation"