Skip to main content

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

Article # 3040761 - Page views: 10


Why does this error appear during an Insight installation?



The 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.


Level of Complexity 



Applies to  

Product Version Build Environment Hardware





Article # 3040761