Steps to Reproduce the Behavior

1. Start Visual Studio .NET.
2. Create a new Windows Application in Visual Basic .NET. Form1 is added to the project by default.
3. Make sure that your project contains a reference to the System.Data namespace.
4. Place a Command button on Form1. Change the Name property of the button to btnTest, and then change the Text property to Test.
5. Use the Imports statement on the System and System.Data namespaces so that you are not required to qualify declarations in those namespaces later in your code. Add this code to the "General Declarations" section of Form1:

   Imports System
   Imports System.Data
   Imports System.Data.OleDb
   Imports System.Data.SqlClient
   					

6. Drag a SqlConnection object to the form.
7. In the Properties window, select New Connection for the ConnectionString property.
8. In the Data Link Properties window, click the Provider tab, select Micrososft Jet 4.0 OLE DB Provider, and then click Next.
9. Select a sample Access database and then click OK.
10. Paste the following code in the btnTest Click event:

        Dim da = New SqlDataAdapter("SELECT * FROM Customers", SqlConnection1)
        Dim ds As New DataSet()
        da.Fill(ds, "Customers")
        MessageBox.Show("Connected Successfully")
    					

11. Save your project. On the Debug menu, click Start to run your project.
12. Click Test. The code fails with the exception mentioned in the "Symptoms" section of this article.
13. Change the ConnectionString as necessary for your environment, and then save and run your project.
14. Click Test. The connection is made successfully.

Back to the top