Choosing the right Oracle Client

26 Dec 2005 11:49 AM

Bora

Hi,
There are two different Oracle Client installed on my computer. And
i'have an application that have to access Oracle. But it chooses the
wrong Oracle Client while it's executing. How can i set the right
Oracle Client for .Net Framework.
Can anyone help me.
Thanks.

Bora

26 Dec 2005 1:54 PM

Christopher Reed

Try changing your Path environmental variable by switching the placements of
your Oracle client paths.

--
Christopher A. Reed
"The oxen are slow, but the earth is patient."

Show quote

"Bora" <jaggerb***@gmail.com> wrote in message
news:1135597784.675908.46570@z14g2000cwz.googlegroups.com...
> Hi,
> There are two different Oracle Client installed on my computer. And
> i'have an application that have to access Oracle. But it chooses the
> wrong Oracle Client while it's executing. How can i set the right
> Oracle Client for .Net Framework.
> Can anyone help me.
> Thanks.
>
> Bora
>

26 Dec 2005 3:05 PM

Bora

Actually there is only one Oracle Client path in environmental variable
Path. But it's also intaresting that in the registery the values that
shows Oracle dll's shows the old ones. Does installing the last version
of MDAC be the solution?
Thanks.

26 Dec 2005 9:05 PM

Christopher Reed

Unfortunately, Oracle installations can be messy to get rid of. What
version of Oracle client do you have installed that is active?
Additionally, what other versions of Oracle have you had on the machine in
question?

--
Christopher A. Reed
"The oxen are slow, but the earth is patient."

Show quote

"Bora" <jaggerb***@gmail.com> wrote in message
news:1135609523.812482.182010@g44g2000cwa.googlegroups.com...
> Actually there is only one Oracle Client path in environmental variable
> Path. But it's also intaresting that in the registery the values that
> shows Oracle dll's shows the old ones. Does installing the last version
> of MDAC be the solution?
> Thanks.
>

27 Dec 2005 8:45 AM

Frans Bouma [C# MVP]

Bora wrote:

> Hi,
> There are two different Oracle Client installed on my computer. And
> i'have an application that have to access Oracle. But it chooses the
> wrong Oracle Client while it's executing. How can i set the right
> Oracle Client for .Net Framework.
> Can anyone help me.

Only if you need to connect to 8i do you need 2 clients on your
machine. Otherwise install the 10g client and you can connect to 9i and
10g. You can switch the oracle home as Christopher says:change the
placements in the path.

FB

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------