Jet 3.5 or 4.0? 
Author Message
 Jet 3.5 or 4.0?

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?

Thanks



Sun, 09 Jan 2005 02:19:55 GMT  
 Jet 3.5 or 4.0?

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)



Sun, 09 Jan 2005 03:23:09 GMT  
 Jet 3.5 or 4.0?

Quote:
> 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?

Jet 3.5 cannot work properly with Access 2002. You should use 4.0.


Sun, 09 Jan 2005 11:49:49 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. OLEDB Jet 3.5 vs 4.0

2. jet 3.5 vs jet 4.0

3. Jet 3.5 or Jet 4.0

4. Convert DAO 3.5 to DAO 3.6 Jet Engine 4.0

5. Jet 4.0 and 3.5 with DataGrid

6. Visual Basic 4.0 16bit, Jet 2.5/3.0/3.5, MS-Access 7.0

7. Jet 3.0 vs Jet 3.5 table locking during queries

8. US/UK Date corruption: Jet 3.5 stored procs via Jet 4

9. Visual Foxpro vs Jet 3.5 -- Comparison (Help!)

10. VFP vs Jet 3.5 Comparison (Help!)

11. Can you force access 2000 to use jet 3.5

12. Performance Problem with Jet 3.5 Engine

 

 
Powered by phpBB® Forum Software