SQL Native Clients Compatibility List?

[Former Member]

Hi

We are using Crystal Report 2008.

The error message is 'Failed to retrieve data from the database. Details:HY000:[Microsoft][SQL Native Client] Connection is busy with results for another command."

as per the following thread: http://scn.sap.com/thread/1759283 is an issue of compatibility of the SQL Native Client with the specific version of Crystal report.

That also seems true in our case. Our reports run with SQL Server Native Client 10.0 but produce the error message with SQL Server Native Client 11.0

Is there such a thing as an "SQL Native Clients Compatibility List by Crystal Reports Version" available?

Thanks.

[former_member183750]

Hi Francisco

About the only "list" I have is as follows:

For OLE DB use:

MS SQL 2005 - OLE DB Provider

MS SQL 2008 - SQL Native 10

MS SQL 2012 - SQL Native 11

MS SQL 2013 - SQL Native 11

For ODBC use:

MS SQL 2005 - SQL Native

MS SQL 2008 - SQL Native 10

MS SQL 2012 - SQL Native 11

MS SQL 2013 - SQL Native 11

You should also ensure that you are using the latest Service Pack for CR 2008. Please contact sales for a download link; 866-681-3435, 1-800-677-7271

Worldwide Office Locations | SAP

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[Former Member]

Thank you for your answer.

I will follow up with our internal business objects administrators and they would call sales if required.

Thanks again.