SQL Server Performance

' 80040e14' - too many arguments specified

Discussion in 'T-SQL Performance Tuning for Developers' started by mntaneja, Sep 5, 2005.

  1. mntaneja New Member

    Hi,

    I am getting this error "' 80040e14' - too many arguments specified" in the line

    rstStoredProc.Open cmdStoredProc, , adExecuteNoRecords

    where rstStoredProc is a recordset used in loop, and error comes for the 2nd iteration(for first iteration it gives the result).
    .Although i have closed the recordset and has set it as nothing at the end of loop and again defined it at the start of loop.
    Any body , any idea..

    MN Taneja
    mntaneja, Sep 5, 2005
    #2

  2. Madhivanan Moderator

    sounds that you specified more values than the number of columns
    Post the query you used

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Sep 5, 2005
    #2

  3. dineshasanka Moderator

    Yes better to post the code here
    dineshasanka, Sep 5, 2005
    #2

  4. mntaneja New Member

    problem solved.

    Thank u all
    mntaneja, Sep 5, 2005
    #2

  5. Madhivanan Moderator

    How did you solve it?

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Sep 5, 2005
    #2

  6. Akthar New Member

    hi mntaneja,

    I am interrested in this issue, can you please post details on the solution

    AKTHAR DILMOHAMUD
    65 BENARES ST
    PORT LOUIS
    MAURITIUS
    Akthar, Sep 5, 2005
    #2

Share This Page