Skip to Content
0
Former Member
Apr 21, 2010 at 04:42 PM

ODBC Connection problem with SQL Native Client driver with CR 11

737 Views

I am having an issue connecting my crystal reports to an ODBC connection that uses the SQL Native Client driver (Version 2005.90.2047.00). My reports work fine when using the SQL Server driver (Version 2000.85.3006.00). The ODBC connection is setup to use Integrated Windows Authentication and is defaulted to go to the correct database. When I test the ODBC connection in the 'ODBC Data Source Adminstrator' it connects fine.

The reports are trying to connect to stored procedures on a SQL Server 2005 database. I can log onto the ODBC connection in CR X1. When I try to set the Datasource connection for one of my reports to the ODBC connection I created, I get the following error:

-


'Some tables could not be replaced, as no match was found in the new data source. Please specify the table required for any unmodified tables.'

-


When I drill down to the SP and try to update the datasource location of the SP directly I get the following errors:

-


'Data Object cannot be opened/accessed'

and

'Unknown Database Connector Error'

-


As I said, I don't have any problems when using the SQL Server 2000 driver. One other thing to mention, when I initially connect to the ODBC connection in CR X1 with the SQL Native Client driver, it asks for a username and password. I leave these blank since I'm using Windows Authentication.

Any advice would be appreciated.

System:

Windows XP

Service Pack 3

Crystal Reports XI:

Product Version 11.0.0.1282