Yes there is. You can either set the TNS_ADMIN variable in the registry or you can set this as environment variable. The value in the Environment Variable takes precedence over the value in the registry.
For registry setting start -> run -> regedt32 goto HKEY_LOCAL_MACHINE -> Software -> Oracle and then from the MENU EDIT -> ADD VALUE VALUE NAME - > TNS_ADMIN Data Type -> REG_EXPAND_SZ Press OK and then enter the path of the TNSNAMES.ORA. Just the directory path, don't include the filename. For setting the environment variable either add a command in autoexec.bat -> SET TNS_ADMIN = Director_path or right click my computer icon on the desktop, go to properties and then click on the environment tab. There click on any of the user variables and in the text fields enter the VARIABLE -> TNS_ADMIN, Value-> Directory_path Regards Naveen -----Original Message----- Sent: Monday, October 07, 2002 10:06 PM To: Multiple recipients of list ORACLE-L Hi . This is a very easy question. I'm usually working with Oracle on UNIX, but today I need to connect to a remote instance from my NT desktop. Is there an equivalent to TNS_ADMIN varaiable in NT? ( I'm trying to force Oracle to use a specific tnsnames.ora file on my machine adn TNS_ADMIN variable is the way to do it on UNIX.) thanks for any help Gene __________________________________________________ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
