TNS:could not resolve the connect identifier-ORA-12154
This is my problem:
We create in oracle 10g a database with tablespace and dbf all as TEST
In the Microsoft ODBC administrator odbcad32:
We have set this:
the driver: oracle 10g driver
data source name: Test_DSN
Client version: 10gR1 and later
When we test the Connection whit this:
(sadmin is the default pass for the database TEST)
the user System is activated and has sadmin set as password.
We get this error:
'ORA-12154: TNS:could not resolve the connect identifier specified'
We checked the following:
tnsnames.ora contain this line:
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.151...)(PORT = 1521))
(SERVICE_NAME = Test)
We cannot find the problem.
NB: we can connect with success using toad, we give this information:
Thanks for helping us, as we are waiting now, and time is running up.
Last edited by Oracle_user; 03-18-2009 at 09:11 AM.
Reason: forgot something
Click Here to Expand Forum to Full Width