Re: TNSNAMES.ORA shared location

Martin J. Malley wrote:
>
> > > I have been running Oracle 7.3 on NT ver 4 environment. I would like to
> > > store tnsnames.ora file on the server and then make it available to all
> > > clients. Do I have to go in the registry and create the environment
> > > variable to do that, or is there another way ?
> If you put a key in the registry under HKEY_LOCAL_MACHINE/Software/Oracle
> call TNS_ADMIN and use to point to the network directory containing
> tnsnames.ora and sqlnet.ora it works fine. For example:
> TNS_ADMIN=G:\ORANT\NETWORK\ADMIN
You can also change the local TNSNAMES.ORA so that it has a single entry which points to your network TNSNAMES.ORA:

ifile=G:\ORANT\NETWORK\ADMIN\TNSNAMES.ORA

-- 
****************************************
Jay Hostetter                          *
D. and E. Communications               *
Ephrata, Pa.  U.S.A                    *
Remove underscores in address to reply.*
****************************************