MDAC 2.5 SDK - Visual FoxPro ODBC Driver

Visual FoxPro ODBC Driver

Microsoft® Visual FoxPro® is a powerful object-oriented environment for database construction and application development. The Microsoft Visual FoxPro ODBC Driver enables applications to open, query, and update data in Visual FoxPro and earlier versions of FoxPro through the Open Database Connectivity (ODBC) interface.

For example, with the Microsoft Visual FoxPro ODBC Driver you can do the following:

Use Microsoft Query to query and update Visual FoxPro data from Microsoft Excel worksheets.
Create mail-merge letters using Visual FoxPro data with Microsoft Word.
Query and update Visual FoxPro views and tables from Microsoft Access.
Use Visual FoxPro as the data store for Microsoft Visual Basic®, Microsoft Visual C++®, and C applications.

You can use the driver to accomplish many other tasks. The following table lists a few topics to help you get started.

To	See
Find out more about using Visual FoxPro data with Microsoft Office	Accessing Visual FoxPro Data from Microsoft Office
Learn about using Visual FoxPro data in Visual Basic applications	Using the Visual FoxPro ODBC Driver with Your Visual Basic Application
View a simple example using Visual C++ to access Visual FoxPro data	Using the Visual FoxPro ODBC Driver with Your C or C++ Application
See a list of supported hardware and software	System Requirements

Driver Architecture

The Microsoft Visual FoxPro ODBC Driver is a 32-bit driver that enables you to open and query a Microsoft Visual FoxPro database or FoxPro tables through the Open Database Connectivity (ODBC) interface. You can access FoxPro data using the following types of applications:

A Microsoft Office application, such as Microsoft Excel or Microsoft Word, that uses Microsoft Query to communicate with ODBC.
An application written in Microsoft Visual C++ or C that uses the ODBC SDK API.
An application written in Microsoft Visual Basic or Microsoft Visual Basic for Applications.

In each case, the request for information uses the ODBC API. The ODBC Driver Manager works with the Visual FoxPro ODBC Driver to open and retrieve data from FoxPro tables and databases.

The architecture is represented in the following diagram: