Symptom
Using "SQL Server Native Client 10.0" in the Crystal Reports XI R1 (11.0) Database Expert
At attempt to connect via OLE DB(ADO) results in the error:
Logon failed
ADO Error Code: 0x80040e73
Source: Microsoft OLE DB Service Components
Description: Format of the initialization string does not conform to the OLE DB specification.
Environment
- MS SQL Server 2008
- Crystal Reports XI R1 (11.0)
Cause
- The name of the SQL Server client dll has been changed from SQLNCLI.dll to SQLNCLI10.dll
- Crystal Reports XI was designed to use SQLNCLI.dll
- Crystal Reports XI does not support connection to MS SQL Server 2008 via SQLNCLI10.dll
Resolution
Upgrade to Crystal Reports XI R2A (11.5)
See KB 1598392 - What is Crystal Reports XI R2A and where did all the CR XI R1 and CR XI R2 updates go?
Keywords
Crystal Reports XI, MS SQL Server 2010, ADO Error Code , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , Problem
Product
SAP Crystal Reports XI ; SAP Crystal Reports XI R2