Connection strings for DBF / FoxPro
Providers to use when connecting to DBF / FoxPro
» Microsoft Jet OLE DB 4.0
» .NET Framework Data Provider for OLE DB (OleDbConnection)
» Microsoft dBASE ODBC Driver
» .NET Framework Data Provider for ODBC (OdbcConnection)
» .NET Framework Data Provider for OLE DB (OleDbConnection)
» Microsoft dBASE ODBC Driver
» .NET Framework Data Provider for ODBC (OdbcConnection)
Finding this site useful?
-Say "Thanks" to Jimmy Engström and the other contributing developers!
-Thank you! »
-Say "Thanks" to Jimmy Engström and the other contributing developers!
-Thank you! »
For your foxpro 2.x DBF you do not need to use dBase or Jet driver, check out the "Visual FoxPro / FoxPro 2.x" section instead and use the VFP driver. Visual FoxPro ODBC and OLEDB drivers work for all Foxpro tables including the oldest foxbase tables and dBaseII, dBaseIII, Clipper files as well.
Microsoft Jet OLE DB 4.0
Type: OLE DB Provider
Usage: Provider=Microsoft.Jet.OLEDB.4.0
Usage: Provider=Microsoft.Jet.OLEDB.4.0
Manufacturer: Microsoft
Customize string example values »
Standard
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password=;
.NET Framework Data Provider for OLE DB
Type: .NET Framework Wrapper Class Library
Usage: System.Data.OleDb.OleDbConnection
Usage: System.Data.OleDb.OleDbConnection
Manufacturer: Microsoft
More info about this wrapper class library »
More info about this wrapper class library »
Customize string example values »
Bridging to Jet OLE DB 4.0
This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password=;
Microsoft dBASE ODBC Driver
Type: ODBC Driver
Usage: Driver={Microsoft dBASE Driver (*.dbf)}
Usage: Driver={Microsoft dBASE Driver (*.dbf)}
Manufacturer: Microsoft
Customize string example values »
Standard
Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;
Remote drives
Driver={Microsoft dBase Driver (*.dbf)};datasource=dBase Files;
SQL syntax example: "select * from \\remotemachine\thefile.dbf"
.NET Framework Data Provider for ODBC
Type: .NET Framework Wrapper Class Library
Usage: System.Data.Odbc.OdbcConnection
Usage: System.Data.Odbc.OdbcConnection
Manufacturer: Microsoft
More info about this wrapper class library »
More info about this wrapper class library »
Customize string example values »
Bridging to Microsoft dBASE ODBC Driver
This is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class.
Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;