DBF / FoxPro connection strings

cslist_top_horizontal

Microsoft Jet OLE DB 4.0

Standard (DBF / FoxPro)

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password=;

How to Use JET in 64 bit environments

Microsoft ACE OLEDB 12.0

Standard

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;

.NET Framework Data Provider for OLE DB

Use an OLE DB provider from .NET

Provider=any oledb provider's name;OledbKey1=someValue;OledbKey2=someValue;

See the respective OLEDB provider's connection strings options. The .net OleDbConnection will just pass on the connection string to the specified OLEDB provider. Read more here.

Microsoft dBASE ODBC Driver

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

Use an ODBC driver from .NET

Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;

See the respective ODBC driver's connection strings options. The .net OdbcConnection will just pass on the connection string to the specified ODBC driver. Read more here.