SAP Knowledge Base Article - Public

1913721 - Tables and Views of Oracle Database aren't displayed in Crystal Reports 2011 when connecting through Oracle ODBC driver (32bit)

Symptom

Tables and Views of Oracle Database aren't displayed in Crystal Reports 2011 when connecting through Oracle ODBC driver(32bit).

Environment

  • SAP Crystal Reports 2011
  • 32bit Oracle 10g/11g ODBC driver(Oracle in OraClient10g/11g)
  • Microsoft ODBC for Oracle

Resolution

  1. Launch Crystal Reports 2011.
  2. Click File > Options.
  3. Click Database tab.
  4. Uncheck Stored Procedures in the Data Explorer.
  5. Click OK.
  6. Click File > Exit.
  7. Launch Crystal Reports 2011.
  8. Click File > New > Standard Report.
  9. Double-click Create New Connection > ODBC (RDO).
  10. Select Data Source Name for Oracle ODBC.
  11. Click Next and type User ID and Password and click Finish.

 

Keywords

ODBC, DSN, System DSN, 32bit, Data Direct, Oracle, ODBC Trace, sqlcon32, Service Name, Data Source Name, Oracle Client, 11g, 10g, rpt, Microsoft ODBC for Oracle, CR Oracle ODBC , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 2011