DBF / FoxPro connection strings

Microsoft Jet OLE DB 4.0

Problems connecting?
Get answer in the DBF / FoxPro Q & A forum

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.

Q&Aask question »

Articlesread all »

Connect

Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.