Error Message Could not load file or assembly ADODB

Error Message: Could not load file or assembly ADODB


Action:

When executing an SSIS package with a COZYROC Task and/or component, the following error is encountered.

Error Message: 
"Could not load file or assembly 'ADODB'..."

Recently, customers have reported an issue with the ADODB module, which is an interop module for connections with the old ADODB technology.  Apparently, the most recent SQL Server versions are not deploying the module in the location it previously existed.

Solutions:

      There are two possible solutions:
  1. The first solution is to install the latest 2.0 version of COZYROC SSIS+ and above. We have included that module as part of our installation
  2. The second solution is to search for the module and then manually register the interop module in the Global Assembly Cache (GAC).  Here is a link where you can find additional information on the Global Assembly Cache Tool.
                          Example:
                        "C:\Program Files (x8.6)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.6.1 Tools\x64\gacutil.exe" -i "C:\Program Files (x86)\Microsoft.NET\Primary Interop Assemblies\adodb.dll"


You must have administrator privileges to use Gacutil.exe.