• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 497
  • Last Modified:

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.
0
Brian__P
Asked:
Brian__P
  • 3
1 Solution
 
Data-ManCommented:
check the version of the oracle drivers on both machines.  

You may also want to check Jet

http://support.microsoft.com/default.aspx?scid=kb;en-us;239114

Mike
0
 
Brian__PAuthor Commented:
All of the ODBC drivers match on the machines.  I did reinstall the 817 client.  I updated the Jet engine with the latest service pack you metioned, but still no success.
0
 
LucasCommented:
You might want to take a look at this one too:

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B108439
0
 
Brian__PAuthor Commented:
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".
0
 
Brian__PAuthor Commented:
The issue was with the Jet drivers.  Thanks everyone!
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now