Re: Location of the tnsnames.ora file in 10.2.0.1 instant client
- From: Bradd Piontek <piontekdd@xxxxxxxxx>
- To: peter.schauss@xxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 29 Nov 2007 12:30:54 -0800 (PST)
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@xxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
