Microsoft KB Archive/236837

= PRB: SQL DTS Wizard Error "Unrecognized Phrase/Keyword" with FoxPro Database =

Article ID: 236837

Article Last Modified on 4/22/2003

-

APPLIES TO


 * Microsoft Open Database Connectivity Driver for Visual FoxPro 5.0

-



This article was previously published under Q236837



SYMPTOMS
When using the Data Transformation Services (DTS) Wizard in Microsoft SQL Server 7.0 to import data from a Microsoft Visual FoxPro database (.DBC), the wizard gives the following error while copying data:

[Microsoft] [ODBC Visual FoxPro driver] Command contains unrecognized phrase/keyword



CAUSE
This is a problem in Visual FoxPro ODBC driver version 6.00.8428.00. The problem was fixed by Visual FoxPro ODBC driver version 6.00.8440.00.



WORKAROUND
Upgrade to Visual FoxPro ODBC driver version 6.00.8440.00. This version of the driver is available as a hot fix, as described in the following Microsoft Knowledge Base article:

231714 BUG: Cannot Export or Open Linked FoxPro Tables Using Latest ODBC Visual FoxPro Driver (6.0.8428.0)

Or, you may obtain an updated copy of the Visual FoxPro ODBC driver as part of the Microsoft Data Access Components(MDAC) version 2.1 SP2 (2.1.2.4202.3) or later, which can be downloaded from the following Web address:

http://msdn.microsoft.com/dataaccess



Steps to Reproduce Behavior
 Set up a DSN using Visual FoxPro ODBC driver and point it to the TestData.dbc file that comes with Visual FoxPro 6.0. Run the SQL 7 DTS Import Wizard from Enterprise Manager, choose Visual FoxPro driver as the source, and select the DSN. Choose the Pubs database as the destination. In the Specify Table Copy or Query dialog box, select Copy table(s) from the source database and choose customers table in the Select Source Tables dialog box. Select Run Immediately from the Save, Schedule and Replicate Package dialog box. Click NEXT and then click FINISH. When the data begins copying, this error will occur:

Failed to transfer 1 table(s). Double-click on the error row to get a detailed description of the error.

Clear this message and double-click the error in the grid to see the ODBC error message.

For more information on SQL Server 7.0 Data Transformation Services, refer to the SQL Server Books Online.

Keywords: kbdatabase kbprb kbfaq kbpending KB236837

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.