Help: Append Parameters in ASP classic
'==============================================
Dim StaffRS, objComm, objParam1, objParam2, objParam3
'Set RecordSet, ADODB.Command
Set StaffRs =Server.CreateObject("ADODB.RECORDSET")
Set objComm = Server.CreateObject("ADODB.Command")
objComm.ActiveConnection = conn 'conn was set earler
objComm.CommandText = "GetStaffReport" 'Stored Procedure
objComm.CommandType = adCmdStoredProc '**Error line**
'Append Parameters
set objParam1 = objcomm.CreateParameter ("People_ID", adVarChar, adParamInput, "123")
objComm.Parameters.Append objparam1
set objparam2 = objcomm.CreateParameter ("DateLow", adDate, adParamInput, 02/02/2006)
objComm.Parameters.Append objparam2
set objparam3 = objcomm.CreateParameter ("DateHigh", adDate, adParamInput, 02/15/2006)
objComm.Parameters.Append objparam3
set StaffRS = objComm.Execute
'Close up work...
'============================================
The Stored Procedure is:
'********************************************
CREATE PROCEDURE GetStaffReport
(@People_ID varchar(32), @Weeklow datetime, @Weekhigh datetime)
AS
SELECT * FROM view_People WHERE
Main_People = @People_ID AND Main_Ending >= @WeekLow AND Main_Ending <= @Weekhigh
Order by Main_Ending DESC
RETURN
GO
'*********************************************
Everything looks correct, but I got an error: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /folder/folder/file.asp, line (**Error line**)
ADODB.Command error '800a0bb9'
Please give me any information about this error, and how to correct it.
Thank you.

