Solved

HY000: Connection is busy with results for another command

Posted on 2009-05-15
13
4,566 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
 
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
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 

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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

758 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now