Oracle 9i release 2 on Win2KSP4. .NET 1.1.. Exception from OracleClient

Hi
I'm using System.Data.Oraclient client developing on the same machine
as the Oracle Server. I'm able to talk to my database via SQLPlus but
when I try to connnect via the OracleConnection's Open() method I get
an error saying

System.Data.OracleClient requires Oracle client software version 8.1.7
or greater.

I have Oracle 9i release 2 on the same machine. Any clues?

TIA

NoSpamMgbworld
Wed Nov 03 21:08:01 CST 2004

Install the full client. SQLPlus only requires part of the Oracle Client to
connect. You will have to pull out the Oracle medium. I am sure there is a
way to install less than that, but I have not taken the time to find out how.

I would also suggest moving to ODP.NET, which you can download free from
otn.oracle.com. It is much better tuned to Oracle 9i. Not sure if this will
alleviate the Oracle Client full install or not.

Plug into your memory bank the fact that Oracle has changed the engine in
10g, so you will have to update software at the time you switch. Currently,
OracleClient does NOT work with 10g, so you have to switch to the ODP.NET
version for 10g (the 9i version of ODP.NET is not compatible with 10g either,
BTW, but the model between different ODP.NET versions is largely compatible).


---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

"phronima" wrote:

> Hi
> I'm using System.Data.Oraclient client developing on the same machine
> as the Oracle Server. I'm able to talk to my database via SQLPlus but
> when I try to connnect via the OracleConnection's Open() method I get
> an error saying
>
> System.Data.OracleClient requires Oracle client software version 8.1.7
> or greater.
>
> I have Oracle 9i release 2 on the same machine. Any clues?
>
> TIA
>

phronima
Wed Nov 10 08:44:22 CST 2004

Thanks for the reply. Is ODP.NET backward compatible?I had not
realised it works with 9i but am aware that it is available for 10g.

Problem was solved by granting machine account ASPNET read/write
access on the Oracle holder where ORACLE_HOME is.


Thanks and regards,
Phronima


"Cowboy (Gregory A. Beamer) - MVP" <NoSpamMgbworld@comcast.netNoSpamM> wrote in message news:<22091FED-FF1B-40F0-A61C-450BC20C3B44@microsoft.com>...
> Install the full client. SQLPlus only requires part of the Oracle Client to
> connect. You will have to pull out the Oracle medium. I am sure there is a
> way to install less than that, but I have not taken the time to find out how.
>
> I would also suggest moving to ODP.NET, which you can download free from
> otn.oracle.com. It is much better tuned to Oracle 9i. Not sure if this will
> alleviate the Oracle Client full install or not.
>
> Plug into your memory bank the fact that Oracle has changed the engine in
> 10g, so you will have to update software at the time you switch. Currently,
> OracleClient does NOT work with 10g, so you have to switch to the ODP.NET
> version for 10g (the 9i version of ODP.NET is not compatible with 10g either,
> BTW, but the model between different ODP.NET versions is largely compatible).
>
>
> ---
>
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
>
> ***************************
> Think Outside the Box!
> ***************************
>
> "phronima" wrote:
>
> > Hi
> > I'm using System.Data.Oraclient client developing on the same machine
> > as the Oracle Server. I'm able to talk to my database via SQLPlus but
> > when I try to connnect via the OracleConnection's Open() method I get
> > an error saying
> >
> > System.Data.OracleClient requires Oracle client software version 8.1.7
> > or greater.
> >
> > I have Oracle 9i release 2 on the same machine. Any clues?
> >
> > TIA
> >