SAP Knowledge Base Article - Public

1711100 - Unable to connect SQL Server 2008 from Crystal reports using Data direct drivers

Symptom

Crystal Reports displays only single field for all tables when connect to SQL Server 2008 database

Environment

  • Crystal Reports 2008 SP3
  • SQL Sever 2008
  • Data Direct drivers 5.3 version

Reproducing the Issue

  1. Install Data Direct drivers 5.3 version on Crystal reports Client system
  2. Create a Crystal Report based on that Data Direct Driver
  3. Crystal Designer can show all tables, but it displays only one field for all the tables

Cause

Crystal Doesn't support Data Direct Drivers connection for SQL Server 2008 Database in 2008 SP3 version

Resolution

  1. Install SQL SERVER 2008 32 bit client on the system
  2. Create a crystal Report using SQL Server 2008 32 bit native connection

Keywords

Data Direct Drivers in Crystal,SQL Server 2008 with Data data direct drivers, single field shown in all tables, SQL SERVER 2008 native connection , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports all versions