Re: Location of the tnsnames.ora file in 10.2.0.1 instant client

Read the instant client setup for windows. I believe you have to set TNS_ADMIN to the correct place (I believe as an environment setting, or maybe it is as a registry key) and the oracle_home has to be part of the path.

• Original Message ---- From: "Schauss, Peter" <peter.schauss_at_ngc.com> To: oracle-l_at_freelists.org Sent: Thursday, November 29, 2007 2:17:34 PM Subject: Location of the tnsnames.ora file in 10.2.0.1 instant client

I am trying to use Oracle Instant Client to connect to a 10g database from SQL Server and I am getting "ORA-12154 TNS:could not resolve the connect identifier specified". I have a tnsnames.ora file located in the ..client_1\network\admin directory with the correct database alias in it.

My questions:

1. How can I determine whether my problem is because the client is not finding the tnsnames.ora file or if it id because the entry for the database in incorrectly specified?
2. If the client is not finding the file, what registry key and name do we have to set to force it to look in the correct directory?

Thanks,
Peter Schauss
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 29 2007 - 14:30:54 CST