Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to specify an Oracle Home in .NET

Re: How to specify an Oracle Home in .NET

From: <yong321_at_yahoo.com>
Date: 20 Jul 2005 09:33:00 -0700
Message-ID: <1121877180.394761.66000@z14g2000cwz.googlegroups.com>


tewall_at_lycos.com wrote:
> Well I must be doing a poor job explaining what I'm wanting, because
> I'm NOT getting the answer I need. What I need is for .NET to specify
> the Oracle home it needs without screwing with the environment that
> everything else on the machine uses. I didn't see how the file you

Hi, tewall,

You did a good job in explaining what you need, even in your original message. In case a .Net process is any way special, I just did a test with a HelloWorld .Net Windows program on my XP Professional which comes with .Net framework. When I run it, I use Process Explorer to see its running environment. Now I go to DOS and type "set foo=bar" (no quotes) and type HelloWorld.exe, the window pops up and I check this running process. Process Explorer tells me there's a new variable foo whose value is set to bar for this process.

So what you need to do is type these commands in DOS, or create a batch file with these lines in it and run the batch file: set oracle_home=xxx
rem optionally cd to the desired folder here yourprogramexecutable

Is that clear? If you can modify your program and want to set oracle_home in your .Net program code, I think you can do it with System.Diagnostics.ProcessStartInfo class.

What Windows version are you using?

Yong Huang Received on Wed Jul 20 2005 - 11:33:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US