locked
Microsoft.Jet.OLEDB.4.0 RRS feed

  • Question

  • I did installed a Microsoft.Jet.OLEDB.4.0

    If Start --> Programs --> ODBC >NET --> ODBC .NET Data Provider -->

    ODBC .NET Data Provider Documentation 

    ODBC .NET Data Provider Readme

    This the only two files or something missing?

    When I do Search = Do not found nothing???


    When I do run the below code I got error message: The Microsoft.Jet.OLEDB.4.0 provider is not register on the local machines.

     

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
    System.EventArgs) Handles MyBase.Load

    Dim sConnectionString As String =
    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\;Extended Properties=Text;"

    Dim objConn As New OleDbConnection(sConnectionString)
    objConn.Open()
    Dim objCmdSelect As New OleDbCommand("SELECT * FROM test.csv", objConn)
    Dim objAdapter1 As New OleDbDataAdapter()
    objAdapter1.SelectCommand = objCmdSelect
    Dim objDataset1 As New DataSet()
    objAdapter1.Fill(objDataset1, "Test")
    DataGrid1.DataSource = objDataset1.Tables(0).DefaultView
    objConn.Close()
    End Sub
    End Class

     

    help please

     

    Monday, March 24, 2008 8:37 PM

Answers

All replies