Connect to dBase IV

[TheWizardofInt]

This worked in VB6 ADO, and now I need it to work in ADO.Net for my ASP.Net page

myconnection = new oledbconnection("Driver={Microsoft dBase Driver (*.dbf)};SourceType=DBF;DBQ=c:\apps\gm57\common;SourceDB=c:\apps\gm57\common\;Exclusive=No")

It needs a provider, and the "Provider=Microsoft.Jet.OLEDB.4.0; statement doesnt cut it

Anyone been down this road before?

Thanks!

 

[TheWizardofInt]

For those who care, this is how to do it

Dim myConnection As OleDb.OleDbConnection
Dim myCommand As OleDb.OleDbCommand
Dim myDataReader As OleDb.OleDbDataReader
Dim strSQLQuery As String

            strSQLQuery = "Select * from contact1 WHERE Company IS NOT NULL"

            myConnection = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & _
                "Data Source=C:\apps\gm57\common;Extended Properties=dBase IV")
            myCommand = New OleDb.OleDbCommand(strSQLQuery, myConnection)
            myConnection.Open()