ODP.NET 10.1.3.0 (Beta) Connectivity

[Guest]

All,
Finding that MS Oracle managed provider has some limitations with
Parameter Building and so on, I switched to ODP.NET cos it has better support
for DeriveParameters option.

Currently I have .Net 1.1 installed and connecting to Oracle 8i Release 3
(8.1.7) using Oracle 8.1.7 client running on Windows 2000 SP4.

I have installed ODP.Net and Oracle 10.1 client as a part of ODP.Net setup.
Followed Installation instructions and looks like it is OK to install new
client with different ORACLE_HOME. Now I have two clients installed on
machine 8i and 10.1.

Tried to create connection and open the connection using ODP.Net. But I get
an exception saying System Error. I also tried to connect to Oracle 8i from
client machine using 10.1 client (Network Config Tool), I get message that
this server version is not supported. Thats a surprise.

If you look at the System Requirement for ODP.Net 10.1.3.0, it says needs
Oracle 8i server with Release 8.1.7. But still I am not able to connect to my
DB which is of the same configuration as above.

Is it because of Multiple Home? I am not sure!
Please help!

Thanks in advance.

Nilesh

 

[Frans Bouma [C# MVP]]

All,
Finding that MS Oracle managed provider has some limitations with
Parameter Building and so on, I switched to ODP.NET cos it has better
support for DeriveParameters option.

Currently I have .Net 1.1 installed and connecting to Oracle 8i Release 3
(8.1.7) using Oracle 8.1.7 client running on Windows 2000 SP4.

I have installed ODP.Net and Oracle 10.1 client as a part of ODP.Net setup.
Followed Installation instructions and looks like it is OK to install new
client with different ORACLE_HOME. Now I have two clients installed on
machine 8i and 10.1.

Tried to create connection and open the connection using ODP.Net. But I get
an exception saying System Error. I also tried to connect to Oracle 8i from
client machine using 10.1 client (Network Config Tool), I get message that
this server version is not supported. Thats a surprise.

If you look at the System Requirement for ODP.Net 10.1.3.0, it says needs
Oracle 8i server with Release 8.1.7. But still I am not able to connect to
my DB which is of the same configuration as above.

Is it because of Multiple Home? I am not sure!
Please help!

and if you install ODP.NET 9.2.0.410 ?

Frans

 

[RoyFine]

Nilesh

Oracle 1g client should be able to connect to Oracle server version 8.1.7.0
and later

If you have an OTN account - check this note from Oracle
http://metalink.oracle.com/metalink/plsql/showdoc?db=Not&id=3437884.8

you can eitehr upgrade to the 10.2 client or install the patchset 10.1.0.3.

regards
roy fine