I am trying to connect Crystal reports 2008 with Oracle 10g using the Oracle server option under ‘Create new connection’ while creating a new crystal report. It gives the error "Failed to open connection. ORA: 12154.
I also tried the work around of using CR data direct driver 5.3 and created an ODBC connection through SYSWOW64. I can create a report locally with this odbc connection but once I export it to infoview, it cannot be refreshed or scheduled as it fails to open the connection. This is urgent. Please suggest!!
I have attached the error message error.doc (49.0 KB)
Crystal 2008 cannot use a 64-bit connection. You need to have the 32-bit Oracle client installed in order for Crystal to use it.
For your ODBC connection, you need to create a 32-bit ODBC connection on the report server that matches the one used in the report. Crystal won’t read a 64-bit connection.
I do have a 32-bit oracle client on my machine and the version is 10.2.0.1. Is it true that Win 7 supports only oracle 10.2.0.5 or higher. But I am able to connect from SQLPlus/ SQL Navigator to the oracle database using the same credentials that I am using in Crystal 2008. But in crstal I get the ORA 12154 error. This is really urgent. Please advise!
If you don’t have the 32-bit client on the server, whatever the version, it won’t work. SQL Plus/SQL Navigator will connect with the 64-bit client, so you’re comparing apples to oranges with that test because Crystal MUST have the 32-bit client.
Sorry for the confusion earlier. Ok let me explain in detail what I tried to do.
I have installed CR Oracle Wire protocol ODBC drivers 5.3 on my local machine. When I use this wire protocol odbc connection to develop a crystal report locally it works fine.
Next I save this report to enterprise. Since I saved it with this odbc connection it will not run as is on the server. So I logged in to CMC and right cliked on this report and set the database configuration and selected the ‘Set custom Database logon information’. Here i specified the server name etc and was able to schedule the report.
Now coming back to developing the crystal report on my local machine WITHOUT the wire protocol ODBC connection that I used in step 1. I am now trying to create the connection using ‘Oracle Server’ option under ‘Create New Connection’ in Crystal reports. When I enter the server and login details it throws the ORA 12154 error locally.
I am trying to use this ‘Oracle server’ option instead of ODBC so that I dont have to go and set database cofig in CMC like i did in step 2 AND MOST IMPORTANTLY the step 1 option of using ODBC does not allow me to use stored procedure. I get the attached error.
Have you looked up what the ORA 12154 error is? That’s the first thing I would do - in this case the error is in your Oracle client configuration, not in Crystal. Resolve this issue and post back if there are any other problems.
I did see the error and what confuses me more is that I am able to connect to the database and run all queries using SQL NAvigator. But its only through Crystal that I cannot connect.
Yes SQL Navigator uses the TNSNAMES file. I have a question. Do you know the compatibilty of crystal 2008 with Win 7 64-bit xox and oracle 10.2.0.1? I think the problem is somewhere here. Below are my current installs:
Crystal reports 2008 SP3, FP3.1
Oracle 10.2.0.1 32-bit client(Does Crystal 2008 work with this specific version?)
Win 7 64-bit OS
(BOB member since 2007-04-16)