What is the best driver to use when u want to connect to an Access XP
Database file streight? i mean, without using a DSN or ODBC
i just saw Jet 3.5 and Jet 4.0 options availables for do that, does there is
any other better way?
Use the Jet OLEDB provider:
'Establish a connection to the data source.
Dim sConnectionString As String
sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=d:\My Documents\db1.mdb"
Dim objConn As New System.Data.OleDb.OleDbConnection(sConnectionString)
objConn.Open()
Dim da As New System.Data.OleDb.OleDbDataAdapter("Select * from Table1", objConn)
Dim ds As New DataSet("AccessDS")
da.Fill(ds, "AccessTable")
Dim dt As DataTable
dt = ds.Tables("AccessTable")
Dim drCurrent As DataRow
For Each drCurrent In dt.Rows
Console.WriteLine("{0} {1}", _
drCurrent("Column1").ToString, _
drCurrent("Column2").ToString)
Next
objConn.Close()
Microsoft MVP (Visual Basic)