Access Violation in Oracle9i provider

Using the Oracle Provider for OLE DB (OraOLEDB.dll 9.2.0.1.0) I get an Access Violation in
ORACORE9.DLL (The instruction at 0x610a3285 refeerenced memory at 0x00630020. The memory could not
be written). I can reproduce the problem with queries like

   select current_timestamp from dual

   or

   select * from OE.ORDERS            (table in Oracle 9i sample db)

against an Oracle 9i installation.

When using Microsofts Oracle Provider I get the error

   Error:       0x80004005
   Source:      Microsoft OLE DB Provider for Oracle
   Description: Data type is not supported.


It looks like the data type TIMESTAMP is not handled by the Oracle/Oracle nor the Microsoft/Oracle
provider, although the MS provider is more polite in saying so.

If I omit the column ORDER_DATE (of data type TIMESTAMP) when querying the OE.ORDERS table, it
works fine.

Have anyone else encountered this behaviour using Oracle9i? Am I missing something obvious or is
the TIMESTAMP data type simply just a no-no from OLE DB/ADO?

Cheers,
Christer

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.