Hi,

I have written the following code in ASP:

    Set objComm = Server.CreateObject("ADODB.Command")
    objComm.ActiveConnection = strConnection
    objComm.CommandText = "spStoredProc"
    objComm.CommandType = adCmdStoredProc
    objComm.Parameters.Append objComm.CreateParameter("UserID", adInteger, _
        adParamInput, , Request.Form("UserID"))
    objComm.Parameters.Append objComm.CreateParameter("RETURN_VALUE",
adInteger, _
        adParamReturnValue)
    objComm.Execute

The stored procedure spStoredProc has 1 input parameter and returns 1
returnvalue.

When I execute the ASP-page the following error occurs:

    Microsoft OLE DB Provider for SQL Server error '80040e14'
    Too many arguments were supplied for procedure spCreateTransaction.
    /asp/vehweb.asp, line 21 //* the objComm.Execute line

What is wrong?!?
Please help...

Thanks,
Jakob.

Hi again!

I solved it myself. Apparently when you use a ReturnParameter that parameter
has to be the first one in the parameters collection.

Y/Jakob