Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rgombina
Constraint Violating Yak Guru
319 Posts |
 Posted - 2007-09-26 : 08:37:12
|
| Hello -I am wondering how to fix this issue. MS Access not displaying date/timestamp instead it's giving me "OLE Object" values. This is an Oracle query from a linked table. If I use pass-thru query I can cast this field into a string to_char(mydate) and the date is displayed okay. However, since I am using ODBC and pass-thru I get this annoying username and password nag all the time which is a battle in it of itself.Thanks,RGO |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-26 : 08:48:44
|
An ORACLE timestamp is a BINARY(16) value (I think).If you cast it to a humanreadable string, it becomes a STRING/TEXT/VARCHAR datatype.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2007-09-26 : 08:52:16
|
| Thanks for the reply. Right, I guess my question is: is there a fix or patch so when I query from Access it display human readable string (date) as opposed to OLE OBJECT values? |
|
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2007-09-26 : 11:22:35
|
I solved it:Create Pass-through query and add the following connection string...View > Properties (while in the pass-thru window)ODBC Connect Str = ODBC;DSN=myOracle;DBQ=myOracle;UID=xxxxx;PWD=xxxxxx |
|
|
|
|
|
|
Oracle date (timestamp) becomes OLE Object