Re: problem with the number 1,000,000?

You need update ODBC driver...

--

Best regards, Vadim Lejnin

Oracle and Unix Administrator company FORS Technical Support Department
Phone: 788-07-60/72/73/74/75
E-mail: support_at_fors.ru, lejnin_at_fors.ru icq#20256486

Rob Diaz <rdiaz_at_helmsmangroup.com> wrote in message news:pf5K2.2152$cP.14881_at_news7.ispnews.com...
> Hi. I have an application that is written in Access and stores its data
in
> Oracle. This application has been running successfully for quite some
time.
>
> Now, I use ODBC to connect to Oracle. We've come across a glitch (perhaps
a
> bug?) and I do not know how to correct it.
>
> The client has inserted a value of 1,000,000 into a numeric field
(double).
> If I go to SQL* and look up the value, it comes back as 1,000,000.
However,
> if I look at it in Access, via ODBC, I get 1.8* 10^302 as the value.
This,
> of course, crashes my system. Now, I've done some testing. I insert
> 1,000,001 and everything works fine. I insert 999,999.99 and everything
is
> fine. I insert 1,000,000.01 and everything is fine. It only fails, and
> ALWAYS fails, when I enter 1,000,000. I even tried 1,000,000,000, and it
> worked.
>
> Does anyone know if there is a problem with the number 1 million in
Oracle's
> ODBC driver? Any help would be greatly appreciated.
>
> Thanks.
>
> --Rob
>
>
Received on Wed Mar 24 1999 - 07:30:09 CST