Access2000 ODBC oracle datatype mismatch

Regarding the following problem:

"The datatype at our oracle 8.0.6 database is NUMBER (10,0). Thats a oracle specification for an long integer and the Oracle ODBC driver 8.0.6.1 should convert it into Long Integer under Access 2000. But it doesn't do so, it is converted in Decimal (10,0). Now we get Problems whem we try to compare a Long Integer (of a not linked table) with an Decimal (10.,0) (of a linked table). And we have a lot of Long Intger fields... :((("

Possible solution:

Go to your client pc's registry: HKEY_LOCAL_MACHINE\Software\ORACLE\ Check all values of the NLS_LANG keys in this folder and subfolders. The NLS_LANG key value on your client pc should match the NLS_LANG value on the oracleserver pc, e.g. if you have: servervalue of NLS_LANG: AMERICAN_AMERICA.WE8DEC8859P1 clientvalue of NLS_LANG: DUTCH_THE NETHERLANDS.WE8ISO8859P1 then you should change the NLS_LANG of your client pc to: AMERICAN_AMERICA.WE8ISO8859P1
Note: the part after the dot does not change! Also replace all occurunces of NA with your servervalue. Received on Wed Feb 26 2003 - 07:33:18 CST