web analytics
ORA-12154: TNS:could not resolve the connect identifier specified Options
codeling
Posted: Thursday, April 6, 2017 9:21:25 AM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 784
Points: 3288

I am getting this error: "ORA-12154 could not resolve the connect identifier specified" when I I am trying access Oracle database using OracleConnection in Visual Studio.

Sponsor
Posted: Thursday, April 6, 2017 9:21:25 AM
 
codeling
Posted: Thursday, April 6, 2017 9:28:53 AM

Rank:Advanced Member
Groups: Member
Joined: 12/11/2015
Posts: 784
Points: 3288

I had 11g clients installed, I found that the following two environment variables were missing in my computer, after I added them, I can access my Oracle database.

ORACLE_HOME = C:\Ora112

TNS_ADMIN = C:\Ora112\FClient\network\admin

Also, doubel check the follwing environment variables is there:

PATH = C:\Ora112\FClient\bin;....

Users browsing this topic
Guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.


© 2017 Digcode.com. All rights reserved.