Could not export data to Excel due to "Could not load file or assembly 'ADODB, Version=7.0.3300.0"

asked 2021-03-18T15:42:08.067+00:00
Darrenington 1 Reputation point

I'm trying to use my personal laptop to pull data from a program called GageView Thickness v6.3.0 and have it export into Microsoft Excel 97-2003 Worksheet (.xls) or Microsoft Excel Worksheet (.xlsx) but when I try to export it has an error and the popup says:

"ExportThicknessToExcel: System.IO.FileNotFoundException: Could not load file or assembly 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=bo3f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
File name: 'ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=bo3f5f7f11d50a3a
at
PanDataStore.ThicknessGage.CThkSetupRecord.ExportToExcel(_Worksheet objSheet, Int32 index, int32 iRow, String strmMode, ArrayList arrHdr) at ExportUtility.frmThkExcelExport.ExportSetupInfoToExcel(_Worksheet objSheet)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind Failure logging, set the registry value
[HKLM/Software/Microsoft/Fusion!EnableLog] (DWORD) to 1.
Note There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value
[HKLM/Software/Microsoft/Fusion!EnableLog].

On a separate company laptop I have no problem using GageView to export data to an excel document and browsing online I seen some people mention a fix for there windows XP computers but I am running windows 10 and I am not sure if these same fixes will work for my windows 10 personal Laptop.

Thanks for reading all this and hopefully someone will be able to help me to get this feature to work.

Entity Framework 6.0
Entity Framework 6.0
A Microsoft open-source object-database mapper for .NET.
216 questions
Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
5,905 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
600 questions
.NET Runtime
.NET Runtime
.NET: Microsoft Technologies based on the .NET software framework.Runtime: The period of time during which a program is being executed in a computer.
953 questions
{count} votes

2 answers

Sort by: Most helpful
  1. answered 2021-03-18T23:03:12.497+00:00
    Duane Arnold 3,211 Reputation points

    So the DLL your program is looking for is not in the Bin folder where I am assuming the Windows desktop exe program is located. You have to install the version it is looking for with Nuget. You can do it with Nuget PM console via Victual Stuido at the project level. If you deploy the program, then all the DLL(s) have to be in the same location as the program.exe so .NET can find the DLL(s).

    https://www.nuget.org/packages/ADODB/

    No comments

  2. answered 2021-03-19T09:57:00.03+00:00
    Cheong00 3,416 Reputation points

    If that program is running under .NET Framework v3.5 runtime, this COM library should exists. (Checked it's located in "%windir%\assembly\GAC\ADODB\7.0.3300.0__b03f5f7f11d50a3a", I just have my machine reinstalled due to dead SSD and haven't installed development tools yet)

    This library does not exists in .NET Framework v4.X, you cannot run this application directly with .NET v4 runtime.

    No comments