Re: Oracle ODBC with MS Visual Studio

In article <3a4307fe.4399756_at_news.online.de>,   knijff_at_bigfoot.com (Ted Knijff) wrote:
> Yes. Decimal point is ",", default decimals is 2.
> Same problem on Win98, WinNT 4.0 sp6a, Win2K prof.
>
> Why does it work with MS-ODBC driver for Oracle ?

Usually, when things like this crop up only in the Oracle driver and not in the Microsoft driver, the culprit is a conflict between the Windows language settings and the NLS settings. The Oracle driver returns data based on the NLS settings while the Microsoft driver relies on the Windows settings. Non-Oracle front-ends (i.e. Access) will also rely on the Windows settings while Oracle front-ends should rely on NLS. Generally, this sort of thing occurs on the boundary between code that uses one setting and code that uses the other.

>
> Ted
>
> On Thu, 21 Dec 2000 16:10:39 GMT, jocave_at_my-deja.com wrote:
>
> >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/
>
> EMail: knijff_at_bigfoot.com
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Dec 22 2000 - 15:55:44 CST