Microsoft KB Archive/157526

= PRB:  as the Remote View Join Type Causes Error =

Article ID: 157526

Article Last Modified on 11/17/2003

-

APPLIES TO


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

-



This article was previously published under Q157526



SYMPTOMS
Selecting "" as the Join type for a Remote or a Local View produces an error message when the view is run.



CAUSE
The syntax of the SQL query built by the Remote or Local View Designer is not correct when the "" Join type is selected.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.



Steps to Reproduce Behavior

 * 1) Using the 32-Bit ODBC Driver Manager, create a DataSource for a database on a Remote Server like the "pubs" database on Microsoft SQL Server.
 * 2) Open a database and create a remote view using the DataSource specified above.
 * 3) Add a table to the Remote View. For example OrdItems in the Microsoft SQL Server pubs database.
 * 4) Add another related table to the view[ASCII 151]-for example, Sales. When the Join Condition dialog box comes up, click Cancel.
 * 5) Click the Join tab of the Remote View Designer. Click the Type drop- down list box and Select "."
 * 6) Enter the names of the table fields on which the Join should be based. For example, set "Field Name" to "Authors.au_id" and "Value" to "Titleauthor_au_id."
 * 7) Right-click the Remote View Designer and click the "Run Query" option.
 * 8) When the "Without join conditions for each table" dialog box appears, click "Yes."

The following error message appears:

Connectivity error:.....Incorrect syntax near the keyword 'ON'.

Additional query words: kbdse VFoxWin

Keywords: kbprb KB157526

-

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

© Microsoft Corporation. All rights reserved.