Could not load file or assembly 'Oracle.DataAccess'

• When starting the AdminTool / ConnectMaster
• When starting a service like WebAPI / Webhook

When starting the AdminTool / ConnectMaster

The error shown in the protocol might look like this:

System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.DataAccess'

or refer to a missing DataAccess.dll in some other way.

The installation of the Oracle Client might not have finished successfully.

In this case the AdminTool / ConnectMaster cannot connect to database.

The following actions in the Command Prompt (cmd.exe) will help analyze the problem:

• Are you able to connect via the sqlplus Tool?
  • sqlplus sys/<password>@<DBname> as sysdba
• The TNS Listener is reachable?
  • tnsping <DBname>
• Is Oracle client present in the PATH environment variable? (e.g.: C:\cm\oracle\product\19.0.0\client_1\bin)
  • set path
• Is the Oracle client installation present in the expected folder?
  • e.g.: C:\cm\oracle\...

Solution

The main reason for this is usually an incorrect path for the installation files. It's best to use short, top-level paths:

C:\temp for the installation packages

C:\cm for the ConnectMaster program

C:\cm\oracle for the Oracle Client

C:\oracle for the Oracle Server

Please make sure the Oracle Client was installed correctly:

How to install Oracle 19c client for ConnectMaster manually

When starting a service like WebAPI / Webhook

Error message: Could not load file or assembly 'Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.

Solution

Copy the <dependentAssembly> block found in the AdminTool / Main application - ..exe.config files

AtWinClient.exe.config ->e.g.: DDesign.WebHookService.exe.config

      <dependentAssembly>
        <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342" />
        <bindingRedirect oldVersion="2.102.0.0-2.112.9999.9999" newVersion="4.122.19.1" />
      </dependentAssembly>