Implemented TNS_ADMIN on NT?

Hi,
Has anyone implemented successfully the following for Oracle8i on NT4

GOAL:
Store the "tnsnames.ora" in a dir. on a shared network drive so that all client NT workstations have access to
that directory.
Specify the TNS_ADMIN variable in the client workstation's registry to point to this shared network dir.

Why would I want to do this? Well this question is from a friend and their shop has a number of test/development databases. For every new database added, the tnsnames.ora is to be modified from client machines. They want a solution so that all clients point to a single tnsnames.ora

The documentation says that TNS_ADMIN var. in the registry can do this.
<FROM DOC>

The search order for SQLNET.ORA and TNSNAMES.ORA follows:

1. Current working directory from where an application is executed b.TNS_ADMIN environment variable If the TNS_ADMIN environment variable is not defined on Windows platforms, TNS_ADMIN it may be in the registry d.If TNS_ADMIN is not defined, $ORACLE_HOME/network/admin on UNIX and ORACLE_HOME\network\admin on Windows platforms
   <END-FROM DOC>
   

I tried doing this but the after setting tns_admin on client workstation registry, SQL*PLUS cannot connect to any database.

Any comments appreciated. Received on Fri May 05 2000 - 18:04:53 CDT