
Error using the Command-object of ADO
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.