Error Type:0x80040E57 and ADODB.Command error '800a0d5d'

Discussion in 'ASP General' started by ern edwar, Nov 15, 2005.

  1. ern edwar

    ern edwar Guest

    Hello,

    i have come to the conclusion i have problem in one of two areas and ive
    spent two days tring to figure it out.

    First the error i get is below with this code:

    ParamList(1) = reportDate
    ParamList(0) = month(reportDate) & "/1/" & Year(reportDate)

    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80040E57)
    [Oracle][ODBC][Rdb]%RDB-E-ARITH_EXCEPT, truncation of a numeric value at
    runtime -SQL-F-DATCONERR, Data conversion error for string '1109-20-05'
    -COSI-F-IVTIME, invalid date or time
    /PICKLER/common/connect.asp, line 201

    So i though oh in my code i have to prepend the pound sign in this part
    of the code below:


    ParamList(1) = "#" & reportDate
    ParamList(0) = "#" & month(reportDate) & "/1/" & Year(reportDate)

    But now i get an error:

    ADODB.Command error '800a0d5d'

    Application uses a value of the wrong type for the current operation.

    /PICKLER/common/connect.asp, line 195

    The code on this line 195 is:
    Cmd.Parameters.Append Cmd.CreateParameter(TempName, TempType,
    adParamInput, 50, TempParam)

    What did i do wrong?

    Any help would be greatly appeciated!!




    *** Sent via Developersdex http://www.developersdex.com ***
     
    ern edwar, Nov 15, 2005
    #1
    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. dcrespo
    Replies:
    1
    Views:
    478
    infidel
    Oct 28, 2005
  2. Chuck
    Replies:
    1
    Views:
    137
    Ray at
    Oct 21, 2003
  3. Rod

    ADODB.Command error '800a0cc1'

    Rod, Jan 28, 2004, in forum: ASP General
    Replies:
    3
    Views:
    244
  4. ern edwar

    ADODB.Command error '800a0d5d'

    ern edwar, Nov 15, 2005, in forum: ASP General
    Replies:
    0
    Views:
    357
    ern edwar
    Nov 15, 2005
  5. Replies:
    1
    Views:
    251
    Bob Barrows [MVP]
    Nov 28, 2007
Loading...

Share This Page