16

I am creating a .NET program that uses odp.net, specifically the 11g version. Our oracle server is running 10g. I am too late in the development process to make a change. Am I heading for trouble? Have you had any experience running 11g client against a 10g server?

OMG Ponies
  • 325,700
  • 82
  • 523
  • 502
Micah
  • 10,295
  • 13
  • 66
  • 95
  • Oracle has historically been very good with backwards compatibility. As the advice below states, check the compatibility matrix and you should be OK. – Bart K Sep 30 '11 at 11:54

4 Answers4

13

Yes, that's OK. Oracle advises that the client version should be >= the server version.

Mark Harrison
  • 297,451
  • 125
  • 333
  • 465
12

You can use odp.net 11 with Oracle server 9, 10 and 11. And yes I have tried all those combinations.

You can use for example odp.net 11 for retrieving geographical information (datatype=mdsys.sdo_geometry) from the Oracle server 9, 10 and 11. I use this example beacuse the possibility to select mdsys.sdo_geometry data has been added to odp.net 11.

tuinstoel
  • 7,248
  • 27
  • 27
4

See the following document on Metalink.

This contains a matrix of ODP Driver Version, Supported Operating System, SQL*Net, RDBMS, .NET Framework, Visual Studio

Subject: Oracle Data Provider for .NET (ODP) Supported Configurations Doc ID: 726240.1

Angelo Marcotullio
  • 801
  • 6
  • 6
  • 2
    This assumes you have a Metalink account. I am guessing here, but most VS developers trying to access Oracle databases don't have that... – DaveN59 Apr 19 '12 at 18:12
2

Using an Oracle 11 client against a 10g database will work. I have previously used the 11g client against a 9i database as well.

Robert Durgin
  • 1,810
  • 19
  • 23