Oracle Issue - Failed to open the connection

[rns031364]

I am trying to load/show a crystal report in a .net viewer application and I'm getting the following error trying to establish the connection.

Failed to open the connection. Details: [Database Vendor Code: 12154 ]

The environment is CRXI R2 using the oracle server connection type, asp.net 2.0 crystal viewer control, oracle 10G client.

I can run the report locally using the crystal IDE without problems. I get the error when I try to load the report through the viewer app on the server. I know code 12154 indicates a TNS names file issue but I can use the tnsnames file from the server on my local machine to access the db with out a problem. Also, the viewer app is running on two other production web servers without a problem. I'm having the issue on a new web server we just built out as a staging server.

Any help is appreciated.
Thanks

 

[Turkbear]

Hi,
On the web server where it fails, open a command window and type ( I assume the Oracle Client is correctly installed on that server):

tnsping <whatever tnsname you use for the reportsource>

If that returns an OK, then try using SqlPlus ( on that same machine) to connect to that instance using the username/password set for the report.







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[rns031364]

tnsping was a success
SqlPlus logon was a success

 

[Turkbear]

Hi,
How are you calling the Report?
Be sure the correct login info is being passed..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[rns031364]

It is a web app with a crystal viewer control on the form. Other web applications call it with a query string that contains the report name, parms and the server/database name for the login. The username/password is in the webconfig file. So I can see the server/database name in the query string so I know what logon info the app is using. As I mentioned, it's working in our production environment so I'm guessing it's got to be something on the oracle setup or possibly some missing crystal install components?? I used the same crystal deployment project to install the crystal parts as I used on the production servers.