Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle ODBC with MS Visual Studio

Re: Oracle ODBC with MS Visual Studio

From: Ted Knijff <knijff_at_bigfoot.com>
Date: Fri, 22 Dec 2000 07:51:29 GMT
Message-ID: <3a4307fe.4399756@news.online.de>

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 ?

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 Received on Fri Dec 22 2000 - 01:51:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US