Too Many Parameters

Results 1 to 3 of 3

Thread: Too Many Parameters

  1. #1
    Join Date
    Dec 1969

    Default Too Many Parameters

    Hi All<BR><BR>I am trying to run a SQL Server stored procedure with two input parameters from an ASP page. <BR><BR>I am receiving an error message:<BR>"Microsoft OLE DB Provider for SQL Server (0x80040E14)<BR>Procedure or function spXXXXX has too many arguments specified."<BR><BR>The Stored Proc expects 2 input parameters, both Integers, and is passed 2 input parameters, both Integers and valid values.<BR><BR>Help, please ????<BR><BR>thanks<BR><BR>Neil<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Too Many Parameters

    Post your stored procedure

  3. #3
    Join Date
    Dec 1969

    Default And the ASP code..

    .. that you are using to call it.<BR><BR>Lastly, while you are at it, do a Response.Write on the SQL string that you are executing. Copy that into Query Analyzer and run it from there.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts