Symptom
- Unable to create Crystal Report
- Error message is thrown
- "Unknown database connector error" thrown in Crystal Reports
- "Viewer could not process an event. Unknown Database COnnector Error [] Error Code0 [CRWEB00000119] thrown in BI Launchpad
Environment
- Crystal Reports 2011
- BI 4.0
- SQL 2008 R2
Reproducing the Issue
- Create a report in Crystal Reports 2011
- Select connection type OLEDB (ADO)
Note: Reports were previously created using OLE DB connection in Crystal Reports 2008 and need to be migrated
Cause
MS SQL Server 2008 requires SQL Native 10 Client as Microsoft doesn’t fully support MDAC or WDAC with SQL 2008
Please refer to below link to access article:
http://msdn.microsoft.com/en-us/library/ms131035(v=sql.105).aspx
Resolution
- Install MS SQL 2008 Client tools and the SQL Native 10 driver in the system DSN
- Convert all reports to SQL Native 10 Driver using the RAS APIs in the Crystal Reports SDK for VS .NET and Java.
Note: CR Designer is a 32 bit application and the DB client should also be of 32 bit. Once published to BI 4.0 then the Client needs to be 64 bit because the BI Servers also run in 64 bit modes.
Keywords
KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
Product
SAP Crystal Reports XI