"ODBC Call Failed" Error When You Run a Query with an Outer Join Against Linked SQL Server Tables

A

Andreas Lauffer

SYMPTOMS
When you create a nested query against linked SQL Server tables and
the top level query contains an outer join, you receive the following
error message when you try to run the query:

ODBC--Call Failed.

[Microsoft][ODBC SQL Server Driver][SQL Server] The column prefix
'name' does not match with a table name or alias name used in the
query. (#107)

Microsoft tells about this error, I copied this text from this link:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;300830

---------------------------------------------
Does anyone knows a solution for JET 3.51?
---------------------------------------------




Andreas Lauffer, easySoft. GmbH, Germany
(e-mail address removed)
 
D

david epsom dot com dot au

rewrite the query into a form that does not have this problem.

(david)
 
V

Van T. Dinh

If you are using a Pass-Through Query, you need to use the
SQL syntax of the database server, NOT JET SQL syntax.
Unfortunately, JET & MS-SQL syntaxes have differences you
need to watch out for.

The best way is to try you SQL String in the (MS-SQL)
Query Analyzer to get it to work correctly and then copy
the MS-SQL SQL String to your Pass-Through Query.

HTH
Van T. Dinh
MVP (Access)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top