tags:

views:

63

answers:

1
Q: 

ODP app working for Oracle clients 10 and 11

Hello,

I want to my app to work for target machines where the Oracle client could be 10 or 11. Is it possible to do it with ODP?

If in my app I reference Oracle.DataAccess.dll from my dev machine (i have ORA client11) - my app works only on target machines with client 11...

If I reference ODP from my client 10 - the app works only for machines with ORA client 10.

Is it possible to develop application(with ODP) which will work for both Oracle client versions 10, 11? I am asking for ORA client versions, not DB versions.

Thanks!

A: 

I have the same question. I have created a program that uses version 11, but some of the users have applications that uses version 10. So if they install client 11, the programs that uses client 10 stops working.

So, is it possible to have both versions in my program? So that the user can change between using 10 or 11 from a setting in my program? Or are there some other solution?

Ragowit  2010-09-29 11:37:49
hi Ragowit,because nobody answered to my question - i came up with this solution:for C#/.Net you may use the app.config file to redirect ranges of versions of a DLL(like Oracle.DataAccess.dll) to a specific version, I think the property was "bindingRedirect"Then compile the application for this version.When you start the app on place with lower version of DLL - it will be used if it fits in the range.I don't know if this is best method toughIf it is not .NET - probably you can use late binding by name
Vlad Bayan  2010-10-20 01:00:51

related questions

Oracle ODP.NET and double clicking hyperlink
Using a ref cursor as input type with ODP.NET
Oracle: Calling multiple procedures in a batch
What is the minimal setup required to deploy a .NET application with Oracle client 11?
The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception
Converting a string to an integer in oracle
Parse CSV (comma separated values) in Oracle
Are Oracle stored procedures faster than in line SQL for a Microsoft.NET application ?
Is ODP.NET redistributable?
ODP.NET OracleCommandBuilder.DeriveParameters for 9i
Oracle client x32 and x64 coexistence
Which Oracle Client and ODP.NET version should I install (using .NET 3.5)
Some data changes in the database. How can I trigger some C# code doing some work upon these changes?
ODP.NET Configuration in Web.config
Why doesn't ODP.NET 11 xcopy deployment work on a machine with Oracle DB 10 installed?
odp.net tracing
Is it ok to use oracle 11g client with a 10g server?
How to get value from an OracleParameter object
Does ODP.net close a ref cursor when the connection closes?
SqlDataSource and Oracle DataProvider I can't seem to be able to use the sqlDataprovider with odp.net
Is it possible to use ODP 11 xcopy deployment and not change the PATH?
Can I use ODAC 11g to access 10g
C# - ODP.NET and ora-01475 must reparse cursor to change bind variable datatype
.NET unable to connect to Oracle DB using Oracle proxy user
ORA-03113: end-of-file on communication channel after long inactivity in ASP.Net app