Microsoft KB Archive/217013

= PRB: FoxPro ODBC Driver Replaced by Visual FoxPro ODBC Driver =

Article ID: Q217013

The information in this article applies to:


 * Microsoft Data Access Components version 2.1
 * Microsoft ODBC Driver for Visual FoxPro, versions 1.0, 2.0, 3.0, 4.0, 5.0, 6.0

SYMPTOMS
When attempting to create a DSN using the installable ISAM ODBC Driver for FoxPro, the following message appears:

The Microsoft FoxPro driver is no longer supported, and has been replaced by  the Microsoft Visual FoxPro driver. When attempting to use an existing DSN or create a DSN-less connection, based on the FoxPro installable ISAM ODBC Driver, the following message appears:

Could not find installable ISAM

CAUSE
The FoxPro installable ISAM ODBC driver is not supported with Microsoft Data Access Components 2.1.

RESOLUTION
Use the Microsoft Visual FoxPro ODBC driver, which is supported with Microsoft Data Access Components 2.1.

STATUS
This behavior is by design.

Steps to Reproduce Behavior
Depending on the action being taken, one of two messages appear.

Example 1:

This example attempts to create a new DSN, using the FoxPro installable ISAM ODBC driver.

1. Install the Microsoft Data Access Components 2.1. Note that SQL Server 7.0

installs MDAC 2.1. 2. Open the ODBC Administrator and click the Add button.

3. Select the ODBC Driver captioned "Microsoft FoxPro Driver (*.dbf)."

4. Click Finish.

5. The following message appears:

The Microsoft FoxPro driver is no longer supported, and has been replaced by  the Microsoft Visual FoxPro driver. Example 2:

This example attempts to access an existing DSN, created using the Microsoft FoxPro installable ISAM ODBC driver.

1. Open the ODBC Administrator and select a DSN based on the "Microsoft FoxPro

Driver (*.dbf)" ODBC Driver. 2. Click Configure.

3. The following message appears:

Could not find installable ISAM Additional query words:

Keywords         : kberrmsg kbGrpFox Version          : WINDOWS:1.0,2.0,2.1,3.0,4.0,5.0,6.0 Platform         : WINDOWS Issue type       : kbprb