Using ODP.NET 10 to connect to oracle 9 database

[Andy Fish]

Hi,

As a workaround to my problem with the microsoft oracle provider (see my
recent post in this same group) I am considering switching to Oracle's own
ODP.NET.

When I go to download it, I can download either version 9i or 10g. Should I
be using the latest version (10.1) regardless of database version or do I
have to use 9 to connect to oracle 9 and 10 to connect to oracle 10?

TIA

Andy

 

[Guest]

According to the docs for the ODP, requirements include:
""Access to Oracle8i Database release 3 (8.1.7) or higher.""

 

[Vincent Dalton]

Andy,

You have to install the 10g version. I am using Oracle 9i with the 10g ODP
tools and all works fine.

 

[Cowboy \(Gregory A. Beamer\)]

If you are ever going to use 10, you need the 10g bits. If you are staying
with 9, you have the option of going either way.

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

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

 

[Frans Bouma [C# MVP]]

Hi,

As a workaround to my problem with the microsoft oracle provider (see
my recent post in this same group) I am considering switching to
Oracle's own ODP.NET.

When I go to download it, I can download either version 9i or 10g.
Should I be using the latest version (10.1) regardless of database
version or do I have to use 9 to connect to oracle 9 and 10 to
connect to oracle 10?

This was the case till 10.1.0.301. Before that, the 10g provider had
issues with 9i, but it works now better on 9i than 9.2.0.x in some
occasions (read: often bugfixes are already in teh 10g one but not in
the 9i one). Also, if you install both, the 10g provider will install
a policy file which will redirect all references to 9.2.x.x to 10.1.x.x
so you can just stick with the 10g one.

It's 100MB larger than the 9i one though. If you don't need to access
to 10g, you can stick with 9i version and upgrade later on. They use
the same type names etc.

FB

--