StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POHow to validate prerequisite for ODP and Oracle Client connection
text
Body
copied!<p>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?</p> <p><strong>How can I check that ODP.NET version 10.2 or higher is installed on target host (registry check is not enopugh)?</strong></p> <p>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.</p> <p>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).</p> <p>So, <strong>How and which components can I check to ensure appropriate versions of ODP and Oracle Client were installed and application will be connected?</strong></p> <p><strong>Thank you in advance!</strong> </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload