posting date to oracle problem

[phil2phil]

Hi,
I'm trying to post a date value into an oracle 9i database, using
classic asp, as that's the language existing app was written in, using
the following code:
to_date('"&date()&"','DD-MMM-YYYY')
that's included in the insert statement, i keep getting the following
error on the page:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Oracle][ODBC][Ora]ORA-01821: date format not recognized

any ideas? i checked the database type in the table, it's set to Date.

Thanks.

 

[Slim]

I assume you have your LCID set wrong.


LCID Chart
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vsmsclcid.asp

how to use
http://search.microsoft.com/search/results.aspx?view=msdn&st=b&na=82&qu=lcid+asp&s=1&swc=4