ODBC to Oracle

  • Thread starter Thread starter Vivek
  • Start date Start date
V

Vivek

Hello All,

I am using Microsoft ODBC for Oracle driver version
2.573.9030.00 to connect to Oracle. When i link to a
table in Oracle from Access 97, one of the fields in that
table is coming up as text even though it is set up as
number in Oracle. That field is declared as Number without
any precision in Oracle. There is another developer who
also links to Oracle tables but he is not having any
problems. This is a strange behaviour but i am not able
to find out what the exact problem is. It works for some
people and doesn't work for some.

Can anyone please help me in resolving this matter.

Thanks

Vivek
 
In Oracle, "NUMBER" is equivalent to "NUMBER(38)". I've found in the past
that anything over "NUMBER(15)" gets treated as Text by Access. You'll need
to change the Oracle data type to this.

It may be dependent on the ODBC driver, as well. But Access's integer data
types can't deal with numbers that high.

Anne
 
Hi. I had changed NUMBER(38) to NUMBER(15) in oracle. Though it solves the datatype mismatch problem. But decimal numbers could not be captured. Eg. 0.8 will be round up to 1. Pls help! Thanks alot.
 
Back
Top