Bill wrote:
We have a corporate database that was upgraded to Oracle 10 and I can
no longer link to or query a table that contains a Time Stamp field
with Access 2003. I've tried the Microsoft ODBC driver and the Oracle
10 and Oracle 8 Driver.
Do you have date fields in the Oracle Db that contain time only? The
Oracle ODBC driver has always (since 7.3.4, at least) trips up over
this. Try writing the query without the fields that have the time in there.
You may also want to try a pass through query, which shouldn't trip up
over the time field.
If I've misunderstood you, use SQLPlus and do a Desc <your table name>
and post the data type of the timestamp field.
--
Tim
http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Be Careful, Big Bird!" - Ditto "TIM-MAY!!" - Me