Oracle Access Field type conversion

[Kalin]

Hi All,

I'm having a problem with an ODBC-call from Access 97 to Oracle 8.0.4.

The problem:

The field types in Oracle are defined as NUMBER(17,2) if these are retrieved by Access they seem to be 'transformed' to TEXT fields.

Does anyone know what causes this and how to solve this ??
Grtz,

Kalin

 

[urmine]

try with Oracle OdBC Driver 8.01.75.00
,MDAC 2.7 and Jet Engine 4

it should work fine

 

[urmine]

kalin just tell if u face still same problems