Microsoft Visual Foxpro Driver

Describes a problem that occurs when you run an ODBC query against Visual FoxPro tables by using the Visual FoxPro ODBC Driver. No records are returned when the WHERE clause includes a date that is not the AMERICAN date format.

Foxpro-->

The system requirements for installation provide the minimum operating system and disk space needed to successfully install the driver. After you've installed the driver, you can select the specific application software you want to use to access Visual FoxPro data.

Installation Requirements

For installation requirements and other information, see the Visual FoxPro ODBC Driver download site.

Microsoft Visual Foxpro Driver Windows Server 2012

Accessing Visual FoxPro Data

To access Microsoft Visual FoxPro or FoxPro 2.x data, you must have the following:

  • ODBC Client Software (automatically installed with the driver)

  • Microsoft Visual FoxPro ODBC Driver

  • Any of the following types of application software:

    • Microsoft Office application such as Microsoft Excel or Microsoft Word

    • C or C++ language ODBC application

    • Microsoft Visual Basic ODBC application

  • Any of the following types of data:

    • Visual FoxPro database or a directory of free tables

    • FoxPro 2.0, 2.5, 2.6 table

Visual Foxpro Odbc Driver Download

The Visual FoxPro ODBC Driver supports double-byte character sets (DBCS). For more information, see International Support.

The driver does not support 16-bit Microsoft Windows 3.1 applications.

-->

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.

Microsoft Visual Foxpro Driver Odbc

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

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

ToSee
Find out more about using Visual FoxPro data with Microsoft OfficeAccessing Visual FoxPro Data from Microsoft Office
Learn about using Visual FoxPro data in Visual Basic applicationsUsing the Visual FoxPro ODBC Driver with Your Visual Basic Application
View a simple example using Visual C++ to access Visual FoxPro dataUsing the Visual FoxPro ODBC Driver with Your C or C++ Application
See a list of supported hardware and softwareSystem Requirements

Microsoft Visual Foxpro Driver Odbc Connection String

For information about downloading and installing the Visual FoxPro ODBC driver, see Visual FoxPro ODBC Driver on MSDN Downloads.