You can loop through the Oracle Homes in the registry. Which home do you
want to select? In the registry there is a number of homes. In most of my
VB app's I use this as the count that I loop through. Do you need a toggle
between the two homes?
>From: "Alex Hillman" <ahillman_at_erols.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: How to find current ORACLE_HOME programmatically
>Date: Wed, 22 May 2002 08:53:44 -0800
>
>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
>To: Multiple recipients of list ORACLE-L
>
>
>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: Alex Hillman
> INET: ahillman_at_erols.com
>
>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: ListGuru_at_fatcity.com (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: Alex Hillman
> INET: ahillman_at_erols.com
>
>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: ListGuru_at_fatcity.com (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).
Send and receive Hotmail on your mobile device:
http://mobile.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jay Wade
INET: fish_dba_at_hotmail.com
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: ListGuru_at_fatcity.com (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).
Received on Wed May 22 2002 - 20:43:23 CDT
