Microsoft Visual FoxPro ODBC Driver connection strings

Connects to

Visual FoxPro

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

Problems connecting?
Get answer in the Visual FoxPro Q & A forum
ODBC DriverDriver={Microsoft Visual FoxPro Driver}Info and driver downloads

Providers

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.