SAP Knowledge Base Article - Public

1833158 - Crystal report fails with database connector error.

Symptom

  • While creating or refreshing a Crystal report, it fails with 'Database connector error'.
  • Crystal report based on SQL Server database fails with the multiple error message.

Environment

  • Crystal Reports 2008
  • Microsoft SQL Server 2008 R2

Reproducing the Issue

  1. Create a Crystal report using SQL Server drivers which are lower than SQL Server 10.0 ODBC drivers.
  2. Now refresh the report.

Cause

The DSN was created using older version of SQL Server ODBC drivers(6.0).

Resolution

  1. Install SQL Server 10.0 ODBC drivers and create a  System DSN using these drivers.
  2. Open the existing report  >> Database menu >> Set data source location >> Create a new ODBC connection >> Update the existing connection with the new one.

Keywords

2008, sql server, odbc, database , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1