Oracle Database Discussions

Hi all,

I have a problem when using SQL Navigator 4.5 tool connect to database, and the errors message popup like: ORA-12154: TNS: Could not resolve service name. But when I'm connect to database by SQLPLUS, it's working fine. I also do ping on server name and tnsping on SID name, they both working fine too. Can you tell me what cause that problen in SQL Navigator 4.5. Is anybody has experience with this problem please help me out.

This is a tnsname.ora file located at c:\oracle\ product\10.2.0\client_1\NETWORK\ADMIN directories

VIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = abcd)(PORT = 1521))
)
(CONNECT_DATA =
(SID = vin)
(SERVER = DEDICATED)
)
)

NOTE: client connect to database server;

Thanks,

Kevin