Oracle ODBC and Access 2000

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Fri, 15 Sep 2000 14:29:34 +0200
Message-Id: <10620.117090@fatcity.com>

Hi List,

I have a problem with Oracle ODBC V8.1.6.1.0 and Access 2000 under = Windows
2000 Professional. I've created a table TEST as follows:

create table test
(nr number(5,2),
nr_lang number(10,3));

insert into test (nr, nr_lang) values(2.5, 1000.123); commit;

Now I tried to select the data from TEST via MS Access 2000 and Oracle = ODBC.
The result is, that the data is shown as "#deleted". If I try to insert data I get ORA-01722 invalid number.

Oracle Support says I have to set the territory settings of Windows = 2000 to
English(USA) and NLS_LANG to AMERICAN_AMERICA.WE...., doesn't work.

Has anybody a solution for this problem? BTW Microsoft ODBC for Oracle driver (Version 2573.4403.00) works with the settings Oracle suggested, = but
not with my local country settings (German).

TIA Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de Received on Fri Sep 15 2000 - 07:29:34 CDT