question

Darrenington-7898 avatar image
0 Votes"
Darrenington-7898 asked cheong00 commented

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


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.

windows-10-generaldotnet-runtimedotnet-entity-frameworkdotnet-adonet
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Forgot to mention that within the
"C:\Program Files\Microsoft.NET"
There is only a folder called "RedistList" and within that folder there 2 files called:
"AssemblyList_4_client"
"AssemblyList_4_extended"

or theres another windows folder
"C:\Windows\assembly"
and I see 108 items listed but none of them are "ADODB, Version=7.0.3300.0". but alot of the files within this folder have the "PublicKeyToken=bo3f5f7f11d50a3a"

0 Votes 0 ·

FYI, strong named assemblies in .NET v4+ are stored in "%windir%\Microsoft.NET\assembly" instead.

0 Votes 0 ·

theres another windows folder

"C:\Windows\assembly"
and I see 108 items listed but none of them are "ADODB, Version=7.0.3300.0". but alot of the files within this folder have the "PublicKeyToken=bo3f5f7f11d50a3a"

Strange... I haven't installed much things yet but still have it. Does your machine have standalone versions of Office installed? (Say, I have Office 2013 installed)
0 Votes 0 ·
DuaneArnold-0443 avatar image
0 Votes"
DuaneArnold-0443 answered

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/



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

cheong00 avatar image
0 Votes"
cheong00 answered cheong00 edited

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.