SAP Knowledge Base Article - Public

1432328 - Schema tables do not appear in the Database Expert of Crystal Reports 2008 when connecting to Oracle 11g through ODBC driver

Symptom

  • Schema tables(e.g scott.emp) do not appear in the Database Expert window

Environment

  • Crystal Reports 2008
  • Oracle 11g Database Server
  • Microsoft ODBC for Oracle(MSORCL32.DLL Version 2.576.3959.00)
  • Oracle in OraClient10g_home1(SQORA32.DLL Version 10.02.00.01)

Reproducing the Issue

  1. Create a new ODBC data source using Microsoft ODBC for Oracle.
  2. Launch Crystal Reports 2008.
  3. Click File > New > Blank Report.
  4. Expand Create New Connection in the Available Data Sources.
  5. Expand ODBC (RDO).
  6. Select ODBC Data Source name in the ODC (RDO) window and click Finish.
  7. Type User ID and Password when prompting connection information window and click Finish.
  8. There are no schema tables listing in the Available Data Sources.

Resolution

Workaround: Instead of using Microsoft ODBC driver for Oracle, use DataDirect Oracle ODBC driver (DataDirect 5.3 Oracle) to connect to Oracle 11g Server.

Keywords

sqlcon, DSN, ODBC, Oracle, Schema , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1