Skip to main content

"Cannot load ODP.NET Provider" Error While Attempting Admin Database Installation Test Connection


Question / Problem: 

Why does this error appear during an Insight installation?

Answer / Solution: 

That error occurs when Oracle's data access library, Oracle.DataAccess.dll isn't properly installed and registered on the machine's Global Assembly Cache ("GAC"). 

There are many reasons for this, however, here are some areas to review to help resolve this. Though this example uses Insight v6.3, these steps can be applied to any supported version of Insight and Oracle.

  • New versions of Oracle Server software, including the Express edition, may install the data access files, but they are not registered by default. Refer to related Oracle documentation and on-line resources for details on how to register ODP.Net. If you are installing Insight v6.3.x, steps to do that using Oracle's OraProvCfg.exe utility are provided in the Insight Installation Guide. Here is an example of a successful registration after following those two steps:
    • gac register.jpg
  • Verify your ODP.Net libraries are installed at a machine-wide level into the GAC, that path is similar to the following (this applies to Oracle's 64-bit data access library installation):

gac file system.jpg



After resolving this issue, you must restart Insight Installation Manager to retest the connection to your Admin database.


Applies to:  

Product Version
Insight 5.x / 6.x