How do I access a .dbf file?

[wouterdeprez]

Hi,

I want to acces a .dbf file with visual studio 2008 express edition, but it doesn't work.When I try to open the connection, i get the error message 'D:\temp\Mijn Documenten\SDT\SDT Klantentool\SDT Klantentool\akttxt.dbf' is no valid path', but I'm sure it's the right directory. The .dbf file is a dBase file, but i don't know which version (I tried III, IV, and 5.0) but always the same error message.

Here's the code:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=D:\temp\Mijn Documenten\SDT\SDT Klantentool\SDT Klantentool\akttxt.dbf;Extended Properties=""dBASE IV;"";"
'Open the database
con.Open() 'Here the error comes up!

sql = "SELECT * FROM akttxt"
da = New OleDb.OleDbDataAdapter(sql, con)
da.Fill(ds, "AktTxt")
con.Close()
MaxRows = ds.Tables("AktTxt").Rows.Count
inc = -1
End Sub

Please can someone help me with this, it's been giving me headaches for days now! If you want I can send the 'akttxt.dbf' file to you.

best regards

[jamesd0142]

try this function:

NOTE: IMPORTS SYSTEM.DATA.OLEDB

Try
            '---- Imports System.Data.OleDb - At top! ----
            '---Usage---
            'Dim oDS As New System.Data.DataSet
            'DBConn("c:\users\users.mdb", "select * from TBLUsers", oDS, DGV1, "table2")
            '---------
            Dim StrConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strSource
            Dim oConn As New System.Data.OleDb.OleDbConnection(StrConn)
            Dim da As System.Data.OleDb.OleDbDataAdapter
            da = New OleDbDataAdapter(strQuery, oConn)
            da.Fill(dataset, tablename)
            'can change DGV - to the name of your DataGrid
            DGV.DataSource = dataset.Tables(tablename).DefaultView
            DGV.Refresh()
            da = Nothing
            dataset = Nothing
            oConn = Nothing
        Catch
            MsgBox("Did not execute correctly")
        End Try
 

usage:

Dim oDS As New System.Data.DataSet
        DBConn("c:\users\users.mdb", "select * from TBLUsers", oDS, DGV1, "table1")
 

[pureenhanoi]

Hi,

I want to acces a .dbf file with visual studio 2008 express edition, but it doesn't work.When I try to open the connection, i get the error message 'D:\temp\Mijn Documenten\SDT\SDT Klantentool\SDT Klantentool\akttxt.dbf' is no valid path', but I'm sure it's the right directory. The .dbf file is a dBase file, but i don't know which version (I tried III, IV, and 5.0) but always the same error message.

Here's the code:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
con.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=D:\temp\Mijn Documenten\SDT\SDT Klantentool\SDT Klantentool\akttxt.dbf;Extended Properties=""dBASE IV;"";"
'Open the database
con.Open() 'Here the error comes up!

sql = "SELECT * FROM akttxt"
da = New OleDb.OleDbDataAdapter(sql, con)
da.Fill(ds, "AktTxt")
con.Close()
MaxRows = ds.Tables("AktTxt").Rows.Count
inc = -1
End Sub

Please can someone help me with this, it's been giving me headaches for days now! If you want I can send the 'akttxt.dbf' file to you.

best regards

I think you better create an ODBC DataSource, an point it to your DBF file
To Create ODBC DataSource:
Open Control Panel > Administrative Tools > ODBC DataSource
On the System DSN tab, click Add
Select "Driver do Mircosoft dBase" driver, and then Finish
Now, name the datasource is AKTTXT, select the right version for dBase file (you can change version latter if it does not correct)
Uncheck the "Use current Directory", and click "Select Directory" to select the folder that containing your dBase file. Finally, click Ok to complete

In VB project, simply use
con.ConnectionString ="AKTTXT"
con.Open

That "AKTTXT" is Datasource name you've made above
If it does not work correctly, try Change dBase version by edit AKTTXT DataSource
With ODBC Data Source, you can access more than one DBF file. Each file is now a Table (like table in MS-Access). File name is the table name (ofcoz, table name have no extension). If you want access another DBF file, simply move this DBF file to the Directory you've selected in ODBC DataSource