Connection strings Examples for Visual FoxPro / FoxPro 2.X

Connection strings Examples for Visual FoxPro / FoxPro 2.X

.NET Data Provider for OLE DB

This is a .NET Class Library from Microsoft. The namespace for this provider is System.Data.OleDb.OleDbConnection.

Standard Security:

Provider=vfpoledb;Data Source=C:\Data\YourDbFolder\YourDbContainer.dbc;Collating Sequence=machine

Note: You can view more OLE DB connection strings for other data provider from other pages.

VFP OLE DB Provider

This is an OLE DB data provider from Microsoft. The usage for this provider is Provider=vfpoledb.

Database container (.DBC):

Provider=vfpoledb;Data Source=C:\Data\YourDbFolder\YourDbContainer.dbc;Collating Sequence=machine;

Free table directory:

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

Note: The data source is the actual folder

Force the provider to use an ODBC DSN:

Provider=vfpoledb;DSN=YourDSN;

Note: The quota " in the string needs to be escaped using your language specific escape syntax.

Microsoft Visual FoxPro ODBC Driver

This is an ODBC driver from Microsoft. The usage for this provider is Driver={Microsoft Visual FoxPro Driver}.

Database container (.DBC):

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

Free Table directory:

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

Note: You can learn more about Visual FoxPro here.

.NET Framework Data Provider for ODBC

This is an ODBC driver from Microsoft. The usage for this provider is System.Data.Odbc.OdbcConnection.

Standard:

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