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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Have you checked the DSN on your computer?

In Data Source (ODBC), you have the option to test whether the DSN is
correctly set.
 
Yes, I have verified the DSN. It works on linking any file but not on the
pass-through query.

Phil
 
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.
 
Back
Top