Hi, I am trying to execute a stored procedure. I created the parameters expected by the stored procedure but when I test the asp page it returns: [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure esppiProduct expects parameter @iSiteId, which was not supplied. <BR>I am providing the siteid. I have another page almost identical to this sproc but it calls a different sproc, that page works. I&#039ve made granted all to public so I don&#039t think its a sql server problem.<BR><BR>Set conSQL = Server.CreateObject("ADODB.Connection")<BR>conSQL. Open "Onyxprod","me","me"<BR>Set objCommand = Server.CreateObject("ADODB.Command")<BR>objCommand .CommandText ="esppiProduct"<BR>Set objRec = Server.CreateObject("ADODB.Recordset")<BR>objComma nd.Parameters.Append<BR>objCommand.CreateParameter ("@iSiteId",adInteger,adParamInput,4,1)<BR>objComm and.ActiveConnection = conSQL<BR>objCommand.Execute<BR><BR>Thank you,<BR><BR>Susan<BR><BR><BR>