Home » Infrastructure » Windows » How to validate prerequisite for ODP and Oracle Client connection (10/11 ODAC, ODAC XCopy, OracleClient, ODP; Windows; )
How to validate prerequisite for ODP and Oracle Client connection [message #467019] Thu, 22 July 2010 01:02
Messages: 10
Registered: July 2010
Junior Member

I have a very simple application on .Net that connect to Oracle using ODP (was compiled with Oracle.DataAccess dll 10.2).
I want to check "connection prerequisite" (application will be able to connect to DB) before installing this aplication on other computers?

How can I check that ODP.NET version 10.2 or higher is installed on target host (registry check is not enopugh)?

I know that I can check ODP entries in registry - but this will not check Oracle Client and compatibility between client and ODP.
Also, if ODP was installed by ODAC XCopy installation - registry may be not updated by new ODP entry.
And - if I am installing on the computer, DB was installed on, Oracle Client can be not installed separately.

And one more issue: When I tried to run "test connection" method from installation, that use referenced dll on machine, that has only ODAC (with ODP) 11, - "Oracle.DataAccess.Client.OracleException The provider is not compatible with the version of Oracle client at Oracle.DataAccess.Client.OracleInit.Initialize()
at Oracle.DataAccess.Client.OracleConnection..cctor()" error message was thrown (policies for both ODAC 10.2 and 11 are exists in GAC (assembly), pointing to Oracle.DataAccess 11 from ODP 2x bin).

So, How and which components can I check to ensure appropriate versions of ODP and Oracle Client were installed and application will be connected?

Thank you in advance!
Previous Topic: No Connection when specifying database name
Next Topic: Oracle 10g
Goto Forum:

Current Time: Sun Jun 26 22:30:44 CDT 2022