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
  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
  3. dineshasanka Moderator

    Yes better to post the code here
  4. mntaneja New Member

    problem solved.

    Thank u all
  5. Madhivanan Moderator

    How did you solve it?

    Madhivanan

    Failing to plan is Planning to fail
  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

Share This Page