1736081 - Database Synonyms on SQL Server are not listed under the Database connection in Crystal Reports 2008

SAP Knowledge Base Article - Public

1736081 - Database Synonyms on SQL Server are not listed under the Database connection in Crystal Reports 2008

Symptom

  • Database Synonyms are not listed under the Database connection in Crystal Reports 2008.

Environment

  • Crystal Reports 2008
  • SQL Server 2008

Reproducing the Issue

  1. Create a Synonym using SQL Server 2008.
  2. Create an ODBC DSN based on Synonym.
  3. While creating a report Synonyms are not listed under the Database connection in Database Expert.

Resolution

  1. Create a SQL Server connection via OLEDB connection.
  2. Synonyms are listed in the Database Expert.

Keywords

Synonyms missing, Crystal Reports SQL Synonyms , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1