Crystal Reports XI R2 - Stored Procedure based reports and SQL Server Native Client 11.0

[Former Member]

We are upgrading to SQL Server 2014 from 2008 and I cannot get my existing reports to connect to my database using SQL Server Native Client 11.0 ODBC driver.

The reports are based on stored procedures.  If I go to "Set Datasource Location" and login to my native ODBC driver and select the SP to update I get the following:

"Data object cannot be opened/accessed"

Followed by:

"Unknown database connector error".

This only seems to be an issue with stored procs.  I have many reports based on database views and all these work fine!

HELP!

Appreciated,

-James

[former_member11696 · Accepted solution]

XI R2 is end of life 5+ years ago. time to upgrade.

R2 is SQL 2008 aware so use the SQL Native 10 client, it should work.

Don

[abhilash_kumar]

Hi James,

What Service Pack is the CR XI R2 on?

You should also upgrade to CR XI R2 SP6 as that is the highest available SP.

-Abhilash