You receive an exception when running .NET application on a computer that does not have Microsoft Data Access Components (MDAC) installed

Steps to reproduce the problem

1. Create a new Visual Basic .NET or Visual C# .NET Console Application project.
2. On the Project menu, click Add Reference.
3. On the .NET tab, double-click adodb in the Components Name list.
4. Replace the existing code with the following code:

   Visual Basic .NET code

   Module Module1
   
      Sub Main()
         Dim cnPubs As ADODB.Connection = New ADODB.ConnectionClass()
         Dim rstblAuthors As ADODB.Recordset = New ADODB.RecordsetClass()
      End Sub
   End Module
   

   Visual C# .NET code

   using System;
   
   namespace MyTestApplication
   {
   	class Class1
   	{
         [STAThread]
         static void Main(string[] args)
         {
            ADODB.Connection cnPubs = new ADODB.ConnectionClass();
            ADODB.Recordset rstblAuthors = new ADODB.RecordsetClass();
         }
   	}
   }

5. On the Build menu, click Build Solution.
6. On a test computer, install only the .NET Framework Redistributable package (dotnetfx.exe). Verify that MDAC is not installed on the test computer.
7. Copy the Windows Application project that you created to the test computer.
8. Run the application. You receive the error message that is described in the "Symptoms" section of this article.

Back to the top