Problem using TNS_ADMIN in registry (Ora. 11g R2 Instant client in Win. 7)
Hi,
I have installed Oracle 11g client Release2 (Instant client instalation) on a PC with Windows 7 (32 bits).
The 'tnsnames.ora' file is in a central server location ('\\MyServer\Data'). For this reason i have use the 'TNS_ADMIN' option.
If I define the environment variable "TNS_ADMIN" with the value '\\MyServer\Data' i can connect succesfully to my database.
But if i define the entry 'TNS_ADMIN'on the window registry, the oracle client can not find the 'tnsnames.ora' and i can not connect to my database. I need this setting. I have made many tests but i can't connect to my database. To discards problems with the shared resource i have copied the 'tnsnames.ora' file in my local machine (drive 'C: \') but this does not work. But the curious cuestion is that if i copy the file 'tnsnames.ora' to the Oracle Home directory ("C:\oracle\product\11.2.0\client_1') and define'TNS_ADMIN' entry in the registry pointing to that location then it works succesfully and i can connect to my database.
Someone could explain why this happens and how i could connect to my database using 'TNS_ADMIN' windows registry setting option to acces to shared 'tnsnames.ora' that is in \\MyServer\Data' location?
Many thanks in advance.