Connection strings for Visual FoxPro / FoxPro 2.x
Providers for Visual FoxPro / FoxPro 2.x
Community Forums
Find solutions and post questions regarding connection string related issues.
For version 8 and up its recommended to use the OLEDB driver as the ODBC driver does not recognize autoincrement fields and does not support stored procedures. The last ODBC update was for VFP 6 (version 6.0.8167) which is also compatible with VFP 7.
VFP OLE DB Provider
Type: OLE DB Provider
Usage: Provider=vfpoledb
Usage: Provider=vfpoledb
Manufacturer: Microsoft
Customize string example values »
Database container (.DBC)
Provider=vfpoledb;Data Source=C:\MyDbFolder\MyDbContainer.dbc;Collating Sequence=machine;
Free table directory
Provider=vfpoledb;Data Source=C:\MyDataDirectory\;Collating Sequence=general;
Force the provider to use an ODBC DSN
Provider=vfpoledb;DSN=MyDSN;
.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 VFP OLE DB Provider
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=vfpoledb;Data Source=C:\MyDbFolder\MyDbContainer.dbc;Collating Sequence=machine;
Microsoft Visual FoxPro ODBC Driver
Type: ODBC Driver
Usage: Driver={Microsoft Visual FoxPro Driver}
Usage: Driver={Microsoft Visual FoxPro Driver}
Manufacturer: Microsoft
Customize string example values »
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;
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.
Loading ad...
.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 Visual FoxPro 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 Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\myvfpdb.dbc;Exclusive=No; NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO;
Selected Articles