[Microsoft][ODBC driver for Oracle][Oracle]ORA-01843: not a valid month

From: Gero Heinze <gero.heinze_at_danet-consult.de>
Date: Mon, 16 Nov 1998 20:08:31 +0100
Message-ID: <3650782F.F545BDAB@danet-consult.de>

Hi all,

I've got a problem accessing ORACLE8 via an MS ODBC-driver from ASP. What I want to do is just to insert a timestamp in a field, that format is DATE.

My SQL statements are as follows:

INSERT INTO table1 ( prodbas_id, produkt_version, versions_planungsstatus, owner_bereich, owner_gruppe, owner ) VALUES (1145, 'V20', 'D', '4', '42', 'CL_A' )
INSERT INTO table2 VALUES ( 10056, '16.11.98 19:49:07', '4', '42', 'CL_A')

What I get is:

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC driver for Oracle][Oracle]ORA-01843: not a valid month

If doing the same with SQL*+, it works.

Thanks in advance for hints.

Gero Received on Mon Nov 16 1998 - 13:08:31 CST