How do I solve ODBC-call error on pass-through query?

G

Guest

When I try to build a pass-through query I set the ODBC Connect string to
ODBC; DSN-AS400 but I always receive an ODBC-call error when I try to run the
query. I don't know how to correct this. I want to be able to run
pass-through queries.
 
V

Van T. Dinh

Have you checked the DSN on your computer?

In Data Source (ODBC), you have the option to test whether the DSN is
correctly set.
 
G

Guest

Yes, I have verified the DSN. It works on linking any file but not on the
pass-through query.

Phil
 
R

Rick Brandt

PhilSH said:
Yes, I have verified the DSN. It works on linking any file but not
on the pass-through query.
Click to expand...

Is there not something more to the error besides "ODBC Call Failed"?

Are you sure your SQL is syntactically correct? IME creating links to an
AS400 is usually the more problem prone area. I never have problems with
pass-through queries.
 

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

Similar Threads

Pass-Through Query Error 1
Pass-Through Query / Multiple ODBC Connections 1
ODBC DSN query issue 1
Access Pass-through Query to SQL Server 6
ODBC Pass-through query with parameter from table 5
ODBC Pass-Through Queries 2
Connection string for pass-through query 2
Access 2007 Pass-Through Query problem 0

Top