asked on

Error message obtained while rolling out first VB.NET app. File or assembly name ADODB or one of its dependencies not found

Error is: An unhandled exception has occurred in a component in your application. System.IO.FileNotFoundException:File or assembly name ADODB or one of its dependencies was not found.

Using ADO to connect to to SQL Server 2000.

Environment: MS Windows 2000 SP3, MDE 2002, Microsoft .NET Framework version 1.1 installed, also MDAC version 2.7 installed. VB.NET version 7.0.9466

Have included references to MS Active X data objects recordset library and multidimensional library without success. Am new to MS .NET Framework, so am wondering if I have to configure the Framework before proceeding?

testn

You should add a reference to ADODB.dll in .NET tab not in COM tab since Microsoft provides primary interop assembly called ADODB.dll which will interop between .NET and COM world. However, it is generated from .NET Framework 1.0. I'm not sure whether it will cause some problem with .NET Framework 1.1

You might find it in C:\WINDOWS\assembly\GAC\ADODB\7.0.3300.0__b03f5f7f11d50a3a

More info:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;318559

http://support.microsoft.com/default.aspx?scid=kb;EN-US;308044

TomDavie

ASKER

I have tried what you suggested, having removed any reference to COM libraries and used only the .NET adodb.dll
file. However, I am still getting the same message.

I have noticed that the error message comes with Microsoft .NET Framework in the title bar. I originally installed the .NET framework verion 1.1 to clear a previous error message which said something about a missing dll file, namely Mscoree.dll on any clients that I rolled the .exe out on.

Installing the Framework has cleared this problem. The framework version which came with VB.net was 1.0 so I am now wondering if there is a compatibility problem with the .NET Framework version I have installed.

ASKER CERTIFIED SOLUTION

testn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

TomDavie

ASKER

No. I have installed the 1.1 framework version on any clients that the .exe is being run on. This is because the Microsoft support site recommended installing the latest version of the framework. This solved the problem with the missing mscoree.dll

However the framework version that was installed when I installed VB.NET was 1.0 I installed the 1.1 version later after the .exe was compiled.

I would rather not upgrade to VB.NET 2003 if possible.

TomDavie

ASKER

I have removed .NET Framework 1.1 and ensured that only version of Framework installed is that which came with the CD. In this case it is v 1.0.3705

The same error message has occurred, ie. FileNotFoundException. File or assembly name ADODB or one of its dependencies was not found.

TomDavie

ASKER

This problem was solved using a the comments from testn. I then had to create a setup file for my VB.NET app. This finally sorted my problem.