Oracle Database Connection Error In Crystal: Database Connector Error: '08501:[Oracle][ODBC][ORA]ORA-03113
Posted on 2009-04-17
When trying to create a new report connection in Crystal Report Xi, the following error messages appear:
Database Connector Error: '08501:[Oracle][ODBC][Ora]ORA-03113: end-of-file on communication channel [Database Vendor Code: 3113 ]'
Them continues after clicking OK:
The dtabase table "Name" cannot be found. Proceed to remove this table from the report?
Further error messages include: 'Failed to retrieve data from the database. Details: ORA-03113: end-or-file on communication channel [Database Vendor Code: 3113]
History of situation:
The change made was to add an ODBC connection using the Oracle 10G driver that was already on the client machine, instead of using an older Oracle73 client driver. This was only done to the ODBC test connection and after that connection failed I removed the test connection.
The Oracle73 Client Driver doesn't work any more either.
Driver versions on the machine
Oracle 9i - v126.96.36.199.14c
Oracle73 - V2.5,,0,1
The types of Connections we're trying to make:
Access 2007 to the Oracle Database - fails at connection
Crystal Xi - Using the Oracle Server Connection -- fails
ODBC: Fails at connection
Please let me know where my failure could be.