Skip to main content
Kofax

How can I fix the error: "Can't load ODP.NET Provider" when trying to connect to KCAF_ADMIN Oracle database in Insight Installation Manager?

21342

QAID # 21342 NOT Published
Please do NOT provide the article number (QAID) and/or URL of this Knowledgebase article or its contents to external customers, as it is NOT Published and/or * INTERNAL ONLY *.

Question / Problem:

How can I fix the error:

"Can't load ODP.NET Provider"

when trying to connect to KCAF_ADMIN Oracle database in Insight Installation Manager?

Answer / Solution:

This error message indicates that the driver hasn’t been properly installed, for example a dll was not registered during the installation.

To get this resolved, it is required to proceed with:

  1. An uninstall of all Oracle ODAC components:
    1. Run the installation wizard again
    2. Click on “Deinstall Product…”
    3. Select the Oracle home to remove, take note of the folder’s location, you’ll need it later
    4. can be ODAC64 or ODAC32, and click on “Remove”
    5. When prompted if you wish to delete the folders, choose the option to delete.
    6. The close and cancel the installation
    7. Repeat this for the 32 bits if you started with 64 bits, or otherwise.
  2. Once you have done this, access the folders in which this was installed, and delete the folders manually
  3. Next, open the folder “C:\Windows\Microsoft.NET\assembly\GAC_32” and delete the following subfolders:
    1. Oracle.DataAccess
    2. Oracle.ManagedDataAccessDTC
    3. Oracle.Web
    4. Policy.4.112.Oracle.DataAccess
    5. Policy.4.112.Oracle.Web
  4. Repeat this for the folder “C:\Windows\Microsoft.NET\assembly\GAC_34” (same subfolders to delete)
  5. Open the folder “C:\Windows\Microsoft.NET\assembly\GAC_MSIL”, and delete the folder “Oracle.ManagedDataAccess”
  6. Now open the registry editor and delete the following keys, sub-keys and values
    1. HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
    2. HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE
  7. Restart the server
  8. And proceed with the installation of ODAC 32 and ODAC 64 as per described previously. Make sure to make them point to different software location, The “Home Base” can be the same.
  9. Reboot the server after the installation of each ODAC driver

Applies to:

Product Version Category
KAFC 1.0 Designer
KAFC 1.0 Designer
KAFC 1.1 Designer
KAFC 1.2 Designer