SAP Knowledge Base Article - Public

1828381 - Unable to create and run Crystal Report when using ADO OLEDB against an SQL 2008 data source

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