Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NET Oracle Client
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
Edited 11-Feb-13 6:49am
v2

1 solution

Rate this: bad
good
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: http://docs.oracle.com/html/E10927_01/featConfig.htm
 
It is now working
  Permalink  

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



Advertise | Privacy | Mobile
Web03 | 2.8.140926.1 | Last Updated 11 Feb 2013
Copyright © CodeProject, 1999-2014
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