Re: Invalid Month error on German Oracle Server 8.1.7 using ADO

From: rs <info_at_bytelife.com>
Date: Wed, 10 Jul 2002 11:10:45 +0200
Message-ID: <3d2bfb75$0$32524$7a0f4ed3@energis-news-env>

Hello James,

Did u check the NLS_LANGUAGE setting ?
E.g. in dutch OKT is not OCTober
In german i imagine u have an UMLAUT in the March (Marz). That's going to be difficult for the database !

Good luck,

Roelof Schierbeek

R.Schierbeek, DBA
sql : www.bytelife.com/sql4dba.htm

newboy <goldstar_at_nospam.aol.com> schreef in
> Hi
> I get an invalid month error when I do an insert from a VB6 app using ADO.
>
> It only happens on a German system for the month of MARCH only !!!
>
> I can fix it by using a different date mask to_date(date, 'DD-MM-RRRR')
>
> 'DD-MON-RRR' doesnt' work even if I set the NLS_DATE parameter to match.
>
> Is it an Microshaft ADO bug?
> Anyone got any suggestion please.
> Thanks
> James
Received on Wed Jul 10 2002 - 04:10:45 CDT