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

SYMPTOMS

You deploy a Microsoft .NET Framework application that accesses a database on a computer. The computer only has the .NET Framework Redistributable package installed. When you run the application, you may receive the following error message:

An unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will be shut down immediately.
QueryInterface for interface ADODB._Command failed.

RESOLUTION

To resolve this problem, install MDAC on the computer. You can download MDAC from the following Microsoft Developer Network (MSDN) Web site:

Data Access downloads
http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp

MORE INFORMATION

Steps to reproduce the problem

Create a new Visual Basic .NET or Visual C# .NET Console Application project.
On the Project menu, click Add Reference.
On the .NET tab, double-click adodb in the Components Name list.

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();
      }
	}
}

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