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
- Launch Crystal Reports 2011.
- Click File > Options.
- Click Database tab.
- Uncheck Stored Procedures in the Data Explorer.
- Click OK.
- Click File > Exit.
- Launch Crystal Reports 2011.
- Click File > New > Standard Report.
- Double-click Create New Connection > ODBC (RDO).
- Select Data Source Name for Oracle ODBC.
- 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 Business View Manager , Problem
Product
SAP Crystal Reports 2011