Re: ODBC to Access

You don't give much info - which version of Oracle etc. This can be the NLS_LANG problem, where a numeric field contains a comma (German version). Either use the 8.0.5.0 client with MS ODBC for Oracle (MDAC 2.1) or the Oracle ODBC Driver version 8.1.6.2 or 8.1.7.

HTH Ted

On Fri, 27 Apr 2001 10:34:38 +0400, "Andrey" <aakit_at_softhome.net> wrote:

>Use ODBC driver supplied with oracle 733 EE. You need sqlnet2 also.
>816/817 ODBC driver works fine also
>
>All other releases unusable
>
>"Andreas Jaendl" <andreas.jaendl_at_weihenstephan.org> wrote in message
>news:9cb0s3$k62$03$1_at_news.t-online.com...
>> Hello,
>>
>> I am trying to run an Access2000 front end to an Oracle database. The
 tables
>> are connected with the ora-ODBC.
>>
>> Inserting data in the Access front end some fields don't work. When I try
 to
>> insert a number in fields, that have the Tpe "Number", size "10" and scale
>> "0", it shows the error-message "...unvalid number".
>>
>> What 's wrong? Thanks for any help, Andreas
>>
>>
>>
>
>

EMail: knijff_at_bigfoot.com Received on Sat Apr 28 2001 - 11:43:23 CDT