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

[Oracle_user]

Hello everybody,

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:
System DSN:
the driver: oracle 10g driver
data source name: Test_DSN
Description:test Database
Server Name:TEST
Client version: 10gR1 and later

When we test the Connection whit this:
Server Name:TEST
user:system
pass:sadmin
(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:
Test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.151...)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Test)
)
)

We cannot find the problem.
NB: we can connect with success using toad, we give this information:
user :system
pass:sadmin
database:TEST

Thanks for helping us, as we are waiting now, and time is running up.

Oracle_user.

[davey23uk]

your tnsnames file is wrong, or you have edited the wrong one

[ales]

The driver could not find tnsnames.ora or could not find the alias in the tnsnames.ora. Most common reasons:
- multiple oracle homes e.g. for the database and for the client (use ora home selector in ora SW menu to select the right one or put the alias to both the files )
- wrong ORACLE_HOME set (check the registry)
- tnsnames.ora in a wrong location (must be %ORACLE_HOME%/network/admin)
- the TNS_ADMIN environment variable set (unset or set to the directory with tnsnames.ora)
- the NAMES.DEFAULT_DOMAIN parameter set in the sqlnet.ora file (unset)