posting date to oracle problem

Discussion in 'ASP General' started by phil2phil, Sep 22, 2005.

  1. phil2phil

    phil2phil Guest

    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.
     
    phil2phil, Sep 22, 2005
    #1
    1. Advertising

  2. phil2phil

    Slim Guest

    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


    "phil2phil" <> wrote in message
    news:...
    > 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, Sep 23, 2005
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. alanb
    Replies:
    2
    Views:
    575
    alanb
    Apr 23, 2004
  2. Peter Grison

    Date, date date date....

    Peter Grison, May 28, 2004, in forum: Java
    Replies:
    10
    Views:
    3,366
    Michael Borgwardt
    May 30, 2004
  3. Benson, John
    Replies:
    1
    Views:
    2,263
    Aurelio Martin
    Jan 28, 2004
  4. Pieter Claerhout
    Replies:
    0
    Views:
    635
    Pieter Claerhout
    Jan 28, 2004
  5. Feyruz
    Replies:
    4
    Views:
    2,338
    Sherm Pendley
    Oct 14, 2005
Loading...

Share This Page