Oracle Database Connection Error In Crystal: Database Connector Error: '08501:[Oracle][ODBC][ORA]ORA-03113

Posted on 2009-04-17
Last Modified: 2013-12-18
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  - v9.
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.
Question by:akrinan
    LVL 6

    Accepted Solution

    I have observed same error when u disconnect from database. try following options

    1. close the file and try reopen. It worked for me.

    2. If you are connecting to database using VPN; try reconnect VPN and reopen the file.

    3. Right click on database connection in crystal and try log off/on to server option in crystal.


    Author Comment

    Hello Namanpatel,

    Thank you for responding. The following is what I found to be the case in my situation. Let me know what you think:

    1. When I closed the file and reopened it the error message still remained.
    2. There is no VPN as it is a trusted connection. But this is something I will investigate.
    3. I checked the database connection by trying to create a new report and the error messages still appeared.

    What your statements help me define is that this is a connection issue between Crystal and the Database.

    The ODBC driver maybe the source because the SQL+ works and Crystal connects to other databases.

    What driver are you using?
    LVL 6

    Expert Comment

    Which connection you are using? Oracle Connection or ODBC?

    Author Comment

    I'm using the RDO connection from within the Crystal Reports connection.
    LVL 6

    Assisted Solution

    Try using Oracle Server from Create new Connection in Database expert.

    Author Comment

    I will tomorrow, and I will update this with my findings. thank you for sticking with me on this issue. Your advice has been invaluable.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Suggested Solutions

    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now