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


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


  • 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

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.


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


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


Crystal Reports 2008 V1