Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle ODBC and Access 2000
Hi, try this:
assuming that Access is used as a front-end to an oracle database: Create on
your test table a primary key to let msaccess determine each row (happened in
mysql,adabas).
oli.
On Fri, 15 Sep 2000, Schoen Volker wrote:
> 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ön
> E-Mail: mailto:v.schoen_at_inplan.de
Received on Fri Sep 15 2000 - 17:39:12 CDT
![]() |
![]() |