Solved

HY000: Connection is busy with results for another command

Posted on 2009-05-15
13
4,761 Views
Last Modified: 2012-05-07
I have Crystal reports that were originally created using an ODBC connection using SQL Server. There reports have 2 SQL commands linked together. When our IT dept changed us over to SQL Native Client, the reports no longer work. They get this error: HY000: Connection is busy with results for another command. Is there a solution for this?
0
Comment
Question by:qbjgqbjg
  • 6
  • 5
  • 2
13 Comments
 
LVL 42

Expert Comment

by:EugeneZ
ID: 24399062
try to create new connection from CR
 
what did they do : <IT dept changed us over to SQL Native Client>?
it is for sql server 2005- what sql server are you using (make sure it has fresh service pack installed)
also Make sure that MDAC was updated on the CR box as well
check
FIX: "Connection is busy with results for another command" error message occurs when you run a linked server query  
http://support.microsoft.com/kb/822668 
0
 

Author Comment

by:qbjgqbjg
ID: 24399431
We are using sql server 2005.  The Fix that you mentioned is for 2000.
0
 
LVL 34

Expert Comment

by:James0628
ID: 24400862
No idea if this will help, but in one of the reports that gets that error, go to File > "Report Options" and see if "Perform Query Asynchronously" is checked.  If it is, try unchecking it and trying the report again.  Like I said, I really don't know if that will help, but the "busy with results for another command" made me think of that option.  Maybe your old connection allowed asynchronous queries and the new one does not.  If unchecking that option fixes the problem, you might see if there is an option in the new connection to allow asynchronous queries.

 James
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 42

Expert Comment

by:EugeneZ
ID: 24400881
ok then
did you install fresh service pack for sql server 2005?
where from are you running CR: is it the same box where sql server 2005 installed?
if there is no sql server 2005 on box with CR - you may need frswh OLEDB drivers -> check fresh MDAC
 
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en
 --
How to check for MDAC version
http://support.microsoft.com/kb/301202
 
====
also - try to switch back to oledb driver for sql server or old one to see if the report is still working from point of view to make sure that it is driver problem
not report was "fixed"..
0
 

Author Comment

by:qbjgqbjg
ID: 24445798
I spoke with Microsoft. The ODBC connection can have MARS set to yes, by doing a register edit. As long as the version of Crystal being used is can use the MARS setting, it will work. I tried it. It seems to be working, but the reports are running much slower than they were onder SQL Server 2000.
0
 
LVL 34

Expert Comment

by:James0628
ID: 24447908
Did you check to see if the reports have "Perform Query Asynchronously" checked and, if so, did you trying unchecking it?  If the reports are running a lot slower using MARS, and turning off "Perform Query Asynchronously" allows them to run without MARS (and they run faster), then that might be a better alternative.

 James
0
 

Author Comment

by:qbjgqbjg
ID: 24452254
I had already looked at the "Perform Query Asynchronously" and it was already unchecked. So that did not allow the reports to run.
0
 
LVL 34

Expert Comment

by:James0628
ID: 24456354
OK.  Just checking.  It seems like you might be stuck with MARS (and the slower performance).  I suppose the last option might be to look at the SQL and see if it can be changed so that it runs without MARS (or go back to the old connection :-).

 James
0
 

Author Comment

by:qbjgqbjg
ID: 24606171
The slow performance turned out not to be related to MARS. Turning on Mars was the solution for this issue. We were able to turn it on for the odbc connection by editing the register,
0
 
LVL 34

Accepted Solution

by:
James0628 earned 500 total points
ID: 24607941
So, you were able to get rid of the error by using MARS, and you were able to get the performance back to normal (or at least not as slow)?  Just out of curiosity, can you tell us what was causing the slow performance?

 James
0
 

Author Comment

by:qbjgqbjg
ID: 24638616
Honestly, we were not able to find the reason for the slow performance. My network people had tried a lot of different things trying to find the solution for the Crystal Issue. So, they just reloaded my computer and that resolved the performance issue. I do not believe the performance issue was related to MARS. But turning on MARS in the ODBC connection did resolve the error we were getting and made it possible for users to run the reports.
0
 
LVL 34

Expert Comment

by:James0628
ID: 24647710
Ah, one of "those" problems.  :-)  Well, I'm glad you were able to fix the performance problem, even if you never really figured out exactly what was causing it.

 James
0
 
LVL 34

Expert Comment

by:James0628
ID: 24663008
Not to complain, but my post wasn't the solution and I don't think I deserve the points.  Looking back through the messages, it seems that you solved this without help from anyone here, in which case you could accept one or more of your own posts as the solution.  Points aside, having the right posts flagged as the solution would help anyone that might come along later with a similar problem.  If you like, you can have the question re-opened.

 James
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

820 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