Alex, As another alternative - can you just define tns_admin at environment level (and / or within the registry under each and every home tree) and then both EMs will (should?) be happy to use the same tnsnames.ora file.
As for current value of oracle_home - one cludge would be to parse the path and see which directory comes first. The other would be to use the Oracle Home selector (which no longer has a cmd line interface - at least the 817 version doesn't) and use a program which lets you pass keystrokes and try to grab the given home name off that screen. However the home selector says your primary home is the one that appears first in the path so maybe just parse the path. Please let the list know if either of these approaches works. HTH, Bruce Reardon -----Original Message----- Sent: Thursday, 23 May 2002 2:54 Looks like no takers, except one whos great advice was to find it somewhere in the registry. Alex Hillman -----Original Message----- Hillman Sent: Monday, May 20, 2002 7:08 PM Hi, guys. I need to find current value of ORACLE_HOME on the client from VB program, running on that client. I understand that it is in the registry somewhere. I have 2 client installations - one is 8.1.7 and another is 9 on the same client. Apparently EM from 9 installation knows that needed tsnames.ora is in 9 ORACLE_HOME and 8.1.7 EM knows that tsnames.ora in 8.1.7. installation. And my VB program select tsnames.ora from 8.1.7 installation Any ideas? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
