FoxPro 2.6 ODBC Connection String

By Robbe Morris

The following ODBC connection string enables access to all .dbf files in the desired folder.

The following ODBC connection string enables access to all .dbf files in the desired
folder.

DBQ=C:\TEMP;Driver={Microsoft dBase Driver (*.dbf)}; DriverId=277;FIL=dBase4.0

In your query strip off the .dbf from the databasename

select count(*) as cnt from mydatabasefilenameminusdbffileextension

Popularity (176 Views)

Biography - Robbe Morris

Robbe has been a Microsoft MVP in C# since 2004. He is also the co-founder of NullSkull.com which provides .NET articles, book reviews, software reviews, and software download and purchase advice. Robbe also loves to scuba dive and go deep sea fishing in the Florida Keys or off the coast of Daytona Beach.