Re: SQLNET 2.0 TNSNAMES.ORA Location

You should have an environment variable pointing to ORACLE.INI

    SET CONFIG=c:\windows\oracle.ini

The ORALCLE.INI file should point to the ORACLE home directory (e.g. c:\orawin) and the NETWORK20 argument within the file should point to the c:\orawin\network directory. The "tsnames.ora" file should be i n the c:\orawin\network\admin directory. At least that's the way it looks on my PC.

Tony
tbrav_at_ctp.com

In article <3uef83$3qq$1_at_mhadf.production.compuserve.com>, David Schornack <75310.2043_at_CompuServe.COM> wrote:
>Does anyone know how to change the location for the tnsnames.ora
>and sqlnet.ora files on a client PCs. They are currently located
>in the subdirectory C:\ORAWIN\NETWORK\ADMIN. Changing the spec
>for NETWORK20 in the ORACLE.INI file does not seem to help.
>Any ideas?
>
>Thanks
>David Schornack

-- 
__________________________________________________________________________
Tony Bravo <tbrav_at_ctp.com>             Cambridge Technology Partners, Inc.
                                  2361 Rosecrans Ave, El Segundo, CA 90245
                                       Tel: 310-297-3804 FAX: 310-297-3900