system.exception can't open Oracle 10g connection

[Guest]

Hi,

I am a total loss. I have VS 2002, Microsoft Oracle data provider and Oracle
10g client installed.

I am trying to open a connection but keep getting a system.exception error.
System.Data.OracleClient requires Oracle client software version 8.1.7 or
greater. I have Oracle 10g installed!

I can't open a connection. It's very frustrating because i have uninstalled,
reinstalled the Oracle client and Microsoft Oracle data provider. If anyone
has any ideas or help that would be great.

Thanks,
a very frustrated developer.

 

[Guest]

Download the free ODP.NET from Oracle. With 10g, there is a specific build of
the ODP.NET that will not work on 9i (and visa versa), so it is not
surprising the OracleClient, from MS, is broken.

http://otn.oracle.com - you will have to register to download


---

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

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

 

[Guest]

Hi,

Thanks, I am working with ODP.NET (which is very nice might I add). I was
responsible for determining which data provider had a faster data download
time; Oracle vs Microsoft. At this point it's Oracle since I cannot get the
Microsoft version to work.

Have you tried to use the Microsoft version with Oracle 10g? And in theory
it should work ... but not sure why it is not working ... or if it's even
been tested by Microsoft against 10g.

Thanks.