Re: Oracle ODBC with MS Visual Studio

From: <jocave_at_my-deja.com>
Date: Thu, 21 Dec 2000 16:10:39 GMT
Message-ID: <91ta1o$agd$1@nnrp1.deja.com>

In article <3a411a3f.4395440_at_news.online.de>, knijff_at_bigfoot.com (Ted Knijff) wrote:
> Hi,
>
> using the Oracle ODBC driver, our numerics get truncated to x.0 on :
>
> select mytext,sum(mynumber) as mynumber from mytable group by mytext
>
> mynumber is numeric (12,2). The digits behind the decimal point don't
> show up in the result set in VB or VFP 6.0.
>
> Using the MS ODBC driver works fine.
>
> NLS_ parameters are set for Germany (decimal point is comma etc.)
>
> Database is Oracle8i 8.1.6 or 8.0.5 EE, ODBC is 8.1.6.

Are your Windows settings also set to German? Sometimes there are problems if your NLS and Windows settings conflict.

Justin Cave

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 21 2000 - 10:10:39 CST