Query against - ODBC Connect Oracle Table

[Ross]

Why can I run an update query on Access XP againts an
ODBC oracle table and get a connection failure when
running the Identical query in Access 97 (on a different
machine)?

The error is "Microsoft [ODBC driver for Oracle]Oracle
ORA-00960; ambiguous column naming in select list [#960]"

What is wrong?

Thanks

Ross

 

[Guest]

Ross
I've gotten the same problem. The guess that we have come up with is that the SQL code is different between the versions of Access and Oracle. Try taking any column from the second table (I'm assuming the table your pulling the update value from) and put in a criteria that you know will always be meet, ex. Where Blah.BlahField1 Is not null, this fixed the probelms for us, we are not sure why, but it did. Good luck
Will

----- Ross wrote: ----

Why can I run an update query on Access XP againts an
ODBC oracle table and get a connection failure when
running the Identical query in Access 97 (on a different
machine)?

The error is "Microsoft [ODBC driver for Oracle]Oracle
ORA-00960; ambiguous column naming in select list [#960]

What is wrong

Thank

Ros