Using ADO to connect to a Visual FoxPro (dbf) table in C++

This is a simple sample showing how to get a database connection using ADO to connect a dbf table.

Introduction

This snippet shows how to connect a Visual Foxpro dbf table and get the field names of the table. It comes from another application in which there should be a database connection interface. And the following is the test function for the interface and it works.

As we know dbf tables are stored independently in some file in the disk, not like a .mdb database whose tables can not be seen at the location the database is via Explorer. So when connecting, the file storing the dbf can be regarded as a database. The function below implements the connection: