Problem with ODBC [message #187252] |
Fri, 11 August 2006 09:01 |
radben
Messages: 1 Registered: August 2006 Location: Czech republic
|
Junior Member |
|
|
Hello. I have got a problem with table, which is linked from Oracle db to MS Access through ODBC. All table columns, which are of type number(x,y), I see in MS Acces like integer type, i.e. without decimal points. For example number 10.123456 is converted to 10123456. Version of Oracle db is 9.2.0.4, version of Oracle ODBC driver is 8.0.6.4 (I was trying 8.1.7.4 as well with the same result).
It's interesting, when I was trying to use Microsoft ODBC driver for Oracle, everything was OK.
Can anybody help me, please? I'd want rather to use Oracle ODBC for work with Oracle tables, than Microsoft one. Thanks.
|
|
|