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

  • Thread starter Thread starter phronima
  • Start date Start date
P

phronima

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
 
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!
***************************
 
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
 
Back
Top