ODBC error with no help

[Norm]

I use Excel to download data from DB2 via an Access
database query. Excel calls a query in an Access database
which gets data from an OBDC connection to a DB2 database
on an AS/400.

When the query is a straight SELECT query against one
file, it works fine. But when I change the query to a
pass-through query so that the work is done on the AS/400
against live files; Excel comes back with:

Reserved Error (|); there is no message for this error.

Access works fine and can run the queries. It's just that
Excel bombs. Any suggestions?

 

[onedaywhen]

...

I use Excel to download data from DB2 via an Access
database query. Excel calls a query in an Access database
which gets data from an OBDC connection to a DB2 database
on an AS/400.

When the query is a straight SELECT query against one
file, it works fine. But when I change the query to a
pass-through query so that the work is done on the AS/400
against live files; Excel comes back with:

Reserved Error (|); there is no message for this error.

Access works fine and can run the queries.

If MS Access can run the queries, I would wager Excel can do it. I
think the problem might be using Jet linked tables as an intermediary,
so try not using them. Rather than querying your Jet database, query
the DB2 database OBDC connection directly from Excel using the same
method you are currently employing, MS Query I assume.

Excel bombs. Any suggestions?

As my granddad used to say, les sanglots longs des violons, d'automne
blessent mon coeur d'une langueur montone.

--

 

[Norm]

I didn't explain the method very well. Access is using
pass-through queries and not linked tables to get the
beginning data. The process is 16 queries and the first 4
are pass-through queries. The first 8 do not work, the
next 7 do work, and the last one doesn't work.

Do you know if Excel can even run a pass-through query in
Access that goes via ODBC (in this case to a DB2 database
on an AS/400)?

Norm