Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Location of the tnsnames.ora file in 10.2.0.1 instant client

Location of the tnsnames.ora file in 10.2.0.1 instant client

From: Schauss, Peter <peter.schauss_at_ngc.com>
Date: Thu, 29 Nov 2007 14:17:34 -0600
Message-ID: <CD9150D80CFCFB42BC73C40791C1E019F52787@XMBIL112.northgrum.com>


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
Received on Thu Nov 29 2007 - 14:17:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US