Crystal report xi command error

Posted on 2013-09-06
Medium Priority
Last Modified: 2013-09-06
I am attempting to create a sql command in crystal reports xi.  I have tried a very basic select statement and I get the following error.  failed to retrieve data from database.  Details:HY000:[Microsoft][SQL Server Native Client 10.0] Connection is busy with results for another command.
Question by:JMcHale
LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 39471153
What version of Crystal are you using?

WHat service pack level?
You need CR XI SP6 or CR2008 SP3


Have you tried using OLEDB connection?


Author Closing Comment

ID: 39471232
I upgraded my odbc connector to sql server native 10.0 and now it works thanks

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…
In the video, one can understand the process of resizing images in single or bulk. Kernel Bulk Image Resizer is an easy to use tool for resizing large number of images. One can add and resize multiple images with this tool in single go. The video sh…

627 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