Access displays 'OLE object' on linked Oracle datetime

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 423,553 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,841 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Oracle advertiser: Programming Forums

Thread Tools Display Modes

Views: 2059 | Replies: 2

Previous Post in Thread

Next Post in Thread

•

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