Multiple oracle homes - need to choose

[bjansson]

I'm using the built in Oracle data provider and I am connecting to an
Oracle 9 database. The problem is that our customer has several oracle
homes and the default oracle home is an old version not working with
..Net. Since we can't change the default home I need a way to set what
Oracle home should be used for my application. How do I do that?

 

[Frans Bouma [C# MVP]]

I'm using the built in Oracle data provider and I am connecting to an
Oracle 9 database. The problem is that our customer has several oracle
homes and the default oracle home is an old version not working with
.Net. Since we can't change the default home I need a way to set what
Oracle home should be used for my application. How do I do that?

You've to set the path to the oracle home you want as the first item
in the PATH environment variable of the process you're in. The easiest
way to do that is via a .cmd file: set the path variable to the value
you need, then start your app. Not sure if this works in all cases or
your case in particular.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

 

[=?iso-8859-1?B?Qmr2cm4=?=]

Then it was as bad as I feared. You could think that Microsoft and/or
Oracle would have thought of a better way to do this.

Anyhow, thank you for answering!