Brian__P
asked on
ODBC Error On One PC but Not Others
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You might want to take a look at this one too:
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B108439
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B108439
ASKER
This is interesting. Access 2002 (Office XP) is installed on both machines. I converted the database to version 2000 and ran the query on computer "A" which originally was broken - and it works. But I can't say this is an Access 97 issue because it works on Access 97 on computer "B".
ASKER
The issue was with the Jet drivers. Thanks everyone!
ASKER