ORA-12154: TNS;could not resolve the connect identifier specified

Star79
Star79 used Ask the Experts™
on
Hello All,
I have a .NET 3.5 application connecting to oracle10g.
But I get the below error:
ORA-12154: TNS;could not resolve the connect identifier specified
I did a tnsping on the service and it returned back with a ok.
Iam able to connect to the DB using the orcale tools for Visualstudio.NET too.
Iam confused and frustruated with this error.
Any help on this?
Thanks,
Ritesh.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2011
Top Expert 2012

Commented:
are you using multiple oracle homes?

Author

Commented:
my system has this folder
C:\Oracle\Ora10g\network\ADMIN
How can I check if Iam using multiple home
Commented:
on windows server check path. in right click on my computer>properties>advanced>environment variable
check path and correspond path to oracle home also check whether tnsnames.ora file is there on that directory with right tnsname entry.

Author

Commented:
Hello,
I did a check on the environment variable and also the  path.The path to oracle home corresponds to tnsnames.ora file on the directory where the file is present.
I did a restart after adding the environment variable but it still didnt work.
Any further help appreciated.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial