OBDC DATA TYPE MAPPING QUESTION

Hi,

I use MS Access as a reporting client for our Oracle database. MS Access connects to the database using ODBC. But there seem to be some problems with the data type mapping of one column called ID which has data type NUMBER(5,0) in Oracle. This column is mapped (linked) to a Longint. Because the application is read-only, this should be no problem.

But it is. When I look in Oracle all ID's are positive (and they should be!), but when I look in Access, some of the are negative! So I read the documentation of Oracle ODBC and found out that there is an intermediate data type mapping in ODBC:

NUMBER(5,0) --> ODBC_SMALLINT --> LONGINT Because the SMALLINT is only 2 bytes, there is corruption of numbers out of the range [- 32768,+32767]. This explains the behaviour.

So my question is: How do I change this data type mapping from SMALLINT to LONG?

Can any one tell me?

Thanks,

Henk Waterlander
The Netherlands Received on Wed Aug 26 1998 - 13:39:44 CDT