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

P

PhilSH

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.
 
P

PhilSH

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