Can anyone tell me what the proper code is to connect to a FoxPro .dbf file in ASP.NET using VB.net? The file is going to be on the local drive. I have looked high and low and I cannot find anything that works correctly. I have found some examples here but they fail when I actually try to retrieve some data from the table. Any help would be greatly papreciated...

Thanks

Hi

Have Connection String for connect databse to your web application ?



shailesh kavathiya
http://www.kavathiya20m.com

if you are using framework 1.1 then use the System.Data.ODBC.ODBCConnection class to connect to the dbf via a DSN

Cheers

Anubhav Kumar

Anubhav is right u can use ODBC to connect to Foxpro

hi, you could use oledbconnection, then you choose the proper provider from connection wizard, the installation of the provider is free for download from microsoft download page, the installer is vfpoledb.exe. after the installation you should give permissions for the provider dll in system32 folder for the aspnet account in order to access the provider.

You can access Visual FoxPro databases and tables in Visual Studio .NET using the Visual FoxPro OLE DB Provider. The Visual FoxPro OLE DB Provider is available through the Visual Studio Server Explorer or by using connection strings in code.

Use a connection string to specify the Visual FoxPro OLE DB Provider and the data source as shown in the following code:

Imports System.Data.OleDb
Public Class ConnectToVFP
        Public Function ADONETOpenVFPDatabase() As Boolean
            Dim bIsConnected As Boolean = True
            Try
                Dim cnn As New OleDbConnection("Provider=VFPOLEDB.1;" + _
                   "Data Source=.\MyTestDatabase.dbc;")
                cnn.Open()
            Catch e As System.Exception
                bIsConnected = False
            End Try
            Return bIsConnected
        End Function
End Class