RSS

Access displays 'OLE object' on linked Oracle datetime

Please support our Oracle advertiser: Programming Forums

Access displays 'OLE object' on linked Oracle datetime

•

Join Date: Jul 2007

Posts: 1

Reputation: jkohlmeyer is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

jkohlmeyer jkohlmeyer is offline

Offline

Newbie Poster

Access displays 'OLE object' on linked Oracle datetime

Jul 25th, 2007

I am using MS Access 2003 to link to an Oracle 10g table utilizing Oracles 10g ODBC driver. When I view the data everything is fine except for the datetime field (which is also an index on the Oracle side).

Access shows a value of "OLE object" in this column rather than anything resembling a date.

Anyone have any suggestions - other than a third party ODBC driver (I did find one that works, but not a viable option).

Thanks in advance,

John

DaniWeb Home > Forums > Web Development > Databases > Oracle > Access displays 'OLE...

Access displays 'OLE object' on linked Oracle datetime

Access displays 'OLE object' on linked Oracle datetime

Access displays 'OLE object' on linked Oracle datetime