Set your default date format to handle the format you are sending (ini.ora I
believe) or
do an alter session nls_date_format=' '
or use the to_date format function
I don't have the manuals in front of me, but those hints should help you.
Jim
Gero Heinze wrote in message <3650782F.F545BDAB_at_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 - 22:13:32 CST
