Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

PRB: FoxPro ODBC Driver Replaced by Visual FoxPro ODBC Driver


View products that this article applies to.

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

↑ Back to the top


Cause

ODBC access to FoxPro 2.x tables was previously supported in version 3.5x and earlier of the installable ISAM ODBC driver (ODBCJT32.DLL). With the release of Microsoft Data Access Components (MDAC) 2.1 and the Visual FoxPro ODBC Driver, ODBC access to FoxPro 2.x tables using the installable ISAM driver (ODBCJT32.DLL version 4.00 and later) is no longer supported.

↑ Back to the top


Resolution

Use the Microsoft Visual FoxPro ODBC driver (version 6.00.), which is supported with MDAC 2.1. To do this, it will be necessary to take the following actions.
  1. Delete the DSN created using the FoxPro 2.x installable ISAM driver.
  2. Create a new DSN using the Visual FoxPro ODBC Driver.
  3. Set the Data Source Name property so that it is the same as the DSN that used the installable ISAM driver.
  4. Under the Database Type options, select "Free Table Directory."
  5. In the Path field, enter the path to the FoxPro 2.x tables that will be used as the ODBC data source.
  6. Click Options to display the Driver panel and deselect the NULL checkbox. Because FoxPro 2.x tables will not accept NULL values, this step will ensure that the ODBC driver does not attempt to insert NULL values into the FoxPro 2.x tables.

↑ Back to the top


Status

This behavior is by design.

↑ Back to the top


More information

MDAC 2.1 installs with the following Microsoft Products:
  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 6.5 Service Pack 5a
  • Microsoft Office 2000
  • Microsoft Windows 98, Second Edition
  • Microsoft Visual Studio 6.0 Service Pack 3

Steps to Reproduce Behavior

Depending on the action being taken, one of two messages appears.

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

↑ Back to the top


Keywords: KB235357, kbprb, kbdatabase

↑ Back to the top

Article Info
Article ID : 235357
Revision : 4
Created on : 12/1/2003
Published on : 12/1/2003
Exists online : False
Views : 473