Microsoft KB Archive/221614

= FIX: Remote View Wizard Gives Error with Spaces in Table Name =

Article ID: 221614

Article Last Modified on 10/15/2002

-

APPLIES TO


 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 5.0a
 * Microsoft Visual FoxPro 6.0 Professional Edition
 * Microsoft Data Access Components 2.5

-



This article was previously published under Q221614



SYMPTOMS
When using the Remote View Wizard to connect to a Visual FoxPro table, you receive the following error in the final step of the wizard:

Connectivity error:[Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized phrase/keyword.

When you press OK in this error dialog box, an Open dialog box appears. Choosing Cancel in the Open dialog box causes the following error:

No table is open in the current work area.



CAUSE
The table name contains a space.



RESOLUTION
Here are two possible workarounds:
 * Remove the space from the table name.

-or-
 * Upgrade to Visual Studio Service Pack 3.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

This bug was corrected in Visual Studio 6.0 Service Pack 3.



Steps to Reproduce Behavior

 * 1) Create a free table and give it a name that contains a space, such as Test 1.
 * 2) Add some data and close the table.
 * 3) Using the Visual FoxPro ODBC driver, create a datasource that points to the table. In the Visual FoxPro driver ODBC setup, make sure to select the "Free Table" option button.
 * 4) In Visual FoxPro, create a database.
 * 5) Add a remote view to the database by using the Remote View Wizard.
 * 6) Choose the datasource created in step 3.
 * 7) Select some fields and click Finish.
 * 8) Choose Save remove view and browse, press Finish, and then provide a name for the remove view.

The error described in the Symptoms section occurs.

Additional query words: KBDSE

Keywords: kbbug kbfix kbdatabase kbwizard kbvs600sp3fix KB221614

-

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

© Microsoft Corporation. All rights reserved.