Connection strings for DBF / FoxPro
Providers for DBF / FoxPro
Community Forums
Find solutions and post questions regarding connection string related issues.
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
Manufacturer Microsoft
Usage Provider=Microsoft.Jet.OLEDB.4.0
Manufacturer Microsoft
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
Manufacturer Microsoft
Usage System.Data.OleDb.OleDbConnection
Manufacturer Microsoft
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)}
Manufacturer Microsoft
Usage Driver={Microsoft dBASE Driver (*.dbf)}
Manufacturer Microsoft
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
Manufacturer Microsoft
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft
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;
Selected Articles