Click here to Skip to main content
13,298,731 members (44,851 online)
Rate this:
Please Sign up or sign in to vote.
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.

Posted 11-Feb-13 7:13am
Updated 11-Feb-13 7:49am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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:

It is now working

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.171207.1 | Last Updated 11 Feb 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100