Connecting ASP.NET web applications with two different Oracle clients

Question

0.00/5 (No votes)

See more:

Where I work, we have an older database which is Oracle 7.3. There are some web application running on a Windows 2008 R2 server in IIS 7 created using ASP.NET which connect to this database with the Oracle 8i client. That worked fine until I needed to create a new web application (ASP.NET) which connects to Oracle 10g R2 using the ODP.NET ODAC 11g. The new program worked correctly with no issues using the new client. The problem is now the old applications will not work and some times it is intermittently switching back and forth where the web application using the 8i client work and the new one does not and vice versa.

When the old application stops working I get ORA-12154: TNS:could not resolve the connect identifier specified

Is there a way to implicently tell the web applications which Oracle client to use? Any help would be greatly appreciated.

Ryan

Posted 11-Feb-13 6:13am

Ryanm1324

Updated 11-Feb-13 6:49am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ryanm1324 · Accepted Answer · 2013-02-11T10:32:00

The problem here is that your path setting got altered by the 11g client install, and now it's appearing first.
Changed it so that the 8i paths appear first, and that should help your older program see it again.

For the newer one, I used the DllPath configuration option to force it to use the 11g client: http://docs.oracle.com/html/E10927_01/featConfig.htm

It is now working