SAP Knowledge Base Article - Public

1616849 - Sybase values repeating in CR using ODBC DSN

Symptom

Crystal Report from a Sybase Stored Procedure returns duplicate data via Sybase ODBC and correct data via Sybase Native

Environment

  • Crystal Reports 2008
  • Sybase ODBC Datasource

Reproducing the Issue

  1. Create a Crystal Report from a Sybase Stored Procedure using ODBC
  2. Refresh the report and notice that some records are repeated
  3. Set Location of Crystal Report to Sybase Native
  4. Notice that records are no longer repeated

Cause

Crystal Reports Native Driver uses SET statements to change ansi null to off.

  • SET ANSINULL OFF
  • SET QUOTED_IDENTIFIER OFF

Sybase ODBC Driver has a setting for this so it is not change automatically by Crystal Reports

Resolution

This issue was resolved by Sybase Support under case 11681002 via the following steps.

  1. Log in with admin rights to the computer.
  2. Use odbc driver version 15.0.0.346 sybdrvodb.dll
  3. uncheck Set ANSI Null

Keywords

  • Sybase
  • Stored Procedure
  • Repeated Records
  • Duplicate Rows
  • ODBC DSN
  • Native
, KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1