Multiple oracle homes - need to choose

27 Jun 2006 8:55 AM

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?

28 Jun 2006 8:50 AM

Frans Bouma [C# MVP]

bjans***@passagen.se wrote:

> 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#)
------------------------------------------------------------------------

29 Jun 2006 9:47 AM

Björn

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!