Developers community number 1 connection string reference

Connection strings 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
Manufacturer Microsoft

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
Manufacturer Microsoft

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}
Manufacturer Microsoft

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.

Microsoft Visual Foxpro site

 
 

.NET Framework Data Provider for ODBC

Type .NET Framework Wrapper Class Library
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft

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;
 
 
Copyright © 2012 ConnectionStrings.com   |   All Rights Reserved   |   Powered by CSAS   |   Send feedback, articles, requests and more connection strings here.