Provider=vfpoledb;Data Source=C:\MyDbFolder\MyDbContainer.dbc;Collating Sequence=machine;

Free table directory

Provider=vfpoledb;Data Source=C:\MyDataDirectory\;Collating Sequence=general;

Connect to a single DBF-file

Provider=vfpoledb;Data Source=C:\MyDataDirectory\MyTable.dbf;Collating Sequence=machine;

Force the provider to use an ODBC DSN

Provider=vfpoledb;DSN=MyDSN;

.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 Visual FoxPro ODBC Driver

Database container (.DBC)

Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\myvfpdb.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO;

Note that DELETED=NO will cause the driver to include deleted rows in the resultset. To not retrieve deleted rows specify DELETED=YES. The terminology is a bit confusing here, a more appropriate keyword would have been IGNORE DELETED instead of DELETED.

Free Table directory

Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=c:\myvfpdbfolder;Exclusive=No;Collate=Machine;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO;

.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.

Visual FoxPro connection strings

VFP OLE DB Provider

Database container (.DBC)

Free table directory

Connect to a single DBF-file

Force the provider to use an ODBC DSN

.NET Framework Data Provider for OLE DB

Use an OLE DB provider from .NET

Microsoft Visual FoxPro ODBC Driver

Database container (.DBC)

Free Table directory

.NET Framework Data Provider for ODBC

Use an ODBC driver from .NET