?
Solved

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

Posted on 2009-04-17
6
Medium Priority
?
2,989 Views
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.0.4.3.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
SQL+: WORKS!

Please let me know where my failure could be.
0
Comment
Question by:akrinan
  • 3
  • 3
6 Comments
 
LVL 6

Accepted Solution

by:
namanpatel earned 2000 total points
ID: 24174180
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.

Thanks,
-Naman.
0
 

Author Comment

by:akrinan
ID: 24177983
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?
0
 
LVL 6

Expert Comment

by:namanpatel
ID: 24181975
Which connection you are using? Oracle Connection or ODBC?
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:akrinan
ID: 24201781
I'm using the RDO connection from within the Crystal Reports connection.
0
 
LVL 6

Assisted Solution

by:namanpatel
namanpatel earned 2000 total points
ID: 24201966
Try using Oracle Server from Create new Connection in Database expert.
0
 

Author Comment

by:akrinan
ID: 24202004
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.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

621 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