•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 373,930 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,224 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.
Please support our Oracle advertiser:
Views: 1740 | 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,172
Reputation:
Rep Power: 4
Solved Threads: 75
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)
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
Linear Mode
- How to access and modify values of a OLE object(Excel Worksheet) (Visual Basic 4 / 5 / 6)
- Storing Text file in Database through VB (Visual Basic 4 / 5 / 6)
- OLE object question (Visual Basic 4 / 5 / 6)
- error : Could not access CDO.Message object (VB.NET)
Other Threads in the Oracle Forum
- Previous Thread: Emailing in oracle With .csv files as attachments
- Next Thread: How to encrypt data during storage?
