Please support our Oracle advertiser: Programming Forums
Views: 2292 | Replies: 2
 |
•
•
Join Date: Jul 2007
Posts: 1
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
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
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,468
Reputation:
Rep Power: 4
Solved Threads: 88
That is because of the incompartibility of Access with Oracle. It shows when there is no compartible data type in access in comparision to Oracle.
Share your Knowledge.
•
•
Join Date: Aug 2007
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Re: Access displays 'OLE object' on linked Oracle datetime I am having the same problem. When I remove columns containg DATE on Oracle table, the Access Linked table works OK - I can sort and filter , etc.
I don't think remove all date fields is a workable solution. Any other ideas? Please, this is very urgent!
I don't think remove all date fields is a workable solution. Any other ideas? Please, this is very urgent!
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
