Knowledge Base

ACC2000: ODBC Call Failed (#200) Error Running a Union Query on Linked Visual FoxPro TablesPSS ID Number: 244904

Article Last Modified on 11/29/2000


--------------------------------------------------------------------------------
The information in this article applies to:


Microsoft Access 2000

--------------------------------------------------------------------------------

This article was previously published under Q244904
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).


SYMPTOMS
When you run a union query with two linked Microsoft Visual FoxPro tables, you may receive the following error message:
ODBC call failed [Microsoft] [ODBC Visual F(#200)]
RESOLUTION
Instead of using linked tables, create a SQL pass-through query that uses the Microsoft Visual FoxPro ODBC driver to perform the union query. To do so, follow these steps:
Create a data source that uses the Visual FoxPro ODBC driver:
Start the ODBC Data Source Administrator.
Click Add to add a data source.
In the list of drivers, click Microsoft Visual FoxPro Driver, and then click Finish.
In the ODBC Visual FoxPro Setup dialog box, type a data source name and a description.
Click Free Table directory, and then type or browse to the directory of free tables to which the data source connects.
Click OK to close the ODBC Visual FoxPro Setup window.
Click OK again to quit the ODBC Data Source Administrator.
Under Objects, click Query, and then click New.
In the New Query window, click Design View, and then click OK.
Microsoft Access displays the Show Table dialog box. Without adding tables or queries, click Close.
On the Query menu, point to SQL Specific, and then click Pass-Through. Microsoft Access displays the SQL Pass-Through Query window.
Type the code for the union query in the SQL Pass-Through Query window. The following is an example. In the example, "LinkedVFoxProTable1" and "LinkedVFoxProTable2" are the names of the two tables.
SELECT * FROM LinkedVFoxProTable1
UNION
SELECT * FROM LinkedVFoxProTable2

Run the query. Note that the query runs without errors and returns the recordset.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
MORE INFORMATION
Steps to Reproduce Behavior
In an open Access 2000 database, link two Visual FoxPro files.
Create the following union query:
SELECT * FROM LinkedVFoxProTable1
UNION
SELECT * FROM LinkedVFoxProTable2

Run the query. Note that you receive the following error message:
ODBC call failed [Microsoft] [ODBC Visual F(#200)]


Additional query words: pra attached err

Keywords: kbbug kberrmsg KB244904
Technology: kbAccess2000 kbAccess2000Search kbAccessSearch



--------------------------------------------------------------------------------

Send feedback to Microsoft

© 2003 Microsoft Corporation. All rights reserved.

2yuniki
> и ничего еще похожего на "SQL pass-through query",

В режиме конструктора - Запрос- Запросы SQL- Запрос к серверу (это он и есть pass-through)