TNS:could not resolve the connect identifier specified

I have an ASP.NET application (2.0), I made a connection to a web server which previously had Oracle client 8.1. We recently had to upgrade the Client to 11.2 and now when I make a connection to the database from the web application, I get the following error:
TNS:could not resolve the connect identifier specified

My connection string is: "Provider=MSADORA.1;DataSource=Test;User ID=test;Password=test"

I'm not sure if I need to change the provider or is the problem with the oracle client.

Any help would be greatly appreciated.
ThurstonclAsked:
Who is Participating?
 
omgangIT ManagerCommented:
My point is that the error message you are receiving indicates the name MSADORA can't be resolved.
OM Gang
0
 
omgangIT ManagerCommented:
When the client was upgraded was the appropriate tnsnames.ora file loaded for it?  The 8.1 client should have had a tnsnames.ora file that allowed MSADORA to be resolved.  I'm thinking you need to include that tnsnames.ora file for the 11.2 client.
OM Gang
0
 
omgangIT ManagerCommented:
See these pics.  I have two clients installed (32- & 64-bit).  Each has to have its own tnsnames.ora file.
OM Gang

two Oracle clients
client 1
client 2
0
 
ThurstonclAuthor Commented:
thanks for your response omgang.

Since MSADORA isn't being resolved, what would be a work around?
0
 
ThurstonclAuthor Commented:
My oracle_home was pointing to the wrong tnsnames.ora file.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.