We have an Access 97 application using oracle tables on an oracle 8.0.5 database. We are in the process of rewritting the application in a newer toolset, but that doesn't get us past this issue.
There is a query that fails with the message "ODBC Call Failed" when it is run on computer "A", but on computer "B" it runs fine. I did an ODBC trace and the error message is:
DIAG [S0022] [Oracle] [ODBC] [Ora] ORA-00904: invalid column name (#904)
Computer "A" and "B" are supposed to be identical images. They have the same versions of Access and Oracle Client. The exceptions are that computer "B" (which works) is a developer's computer so it has Toad and other software.
The query is fairly complicated. It is a query of two other queries using an outter join to look for missing records. Removing the outer join allows the query to run on computer "A" (broken). But, the whole point of the query is the outer join. I've attempted to rewrite the query in different ways, but with no success.