undefined name in pass-through query

A

Angie

I'm writing a pass-through query joining a table from within the existing
database to an ODBC linked table via DB2. I keep getting the following error:

[IBM][CLI Driver][DB2] SQL0204N "ODWOWN01_MY_TABLE" is and undefined name.
SQLSTATE=42704 (#-204)

This is my first shot at a pass-through query, so forgive my ignorance. Any
assistance would be greatly appreciated.
 
B

Brendan Reynolds

Angie said:
I'm writing a pass-through query joining a table from within the existing
database to an ODBC linked table via DB2. I keep getting the following
error:

[IBM][CLI Driver][DB2] SQL0204N "ODWOWN01_MY_TABLE" is and undefined name.
SQLSTATE=42704 (#-204)

This is my first shot at a pass-through query, so forgive my ignorance.
Any
assistance would be greatly appreciated.
Click to expand...


As I understand it, the pass-through query is processed entirely by the
server database, without any intervention by the JET database engine, so
your pass-through query can refer only to objects that are visible to the
server. You can't include a local JET table, as that is not visible to the
server.
 

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 and variables 2
ODBC Pass-through query with parameter from table 5
Question on Pass-through Query 4
Pass-Through Query / Multiple ODBC Connections 1
Access Pass-through Query to SQL Server 7
Using pass-through query results in forms 0
Pass through query to oracle db 2

Top