accessing stored procedure from asp Page

[Guest_imported]

I have a stored procedure that expects 1 parameter on sql server that I want to call from an asp page, I have typed the following code:
Set rsloop = Server.CreateObject("ADODB.Recordset&quot
dim com
set com=server.CreateObject("adodb.command&quot
set para=com.CreateParameter("param",adVarChar,adParamInput,20) 'line XX com.Parameters.append para
com.Parameters("param&quot="3/11/1999"
with com
.ActiveConnection =objdbConnection
.CommandText ="procgenTestNber"
.CommandType =adCmdStoredProc
end with
set rsloop = com.Execute
I get the following error when the page loads:
ADODB.Command error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

The error points to the line that i have marked as line XX
I will apprecite your help.

 

[mkuan]

Try casting the date before assigning it:

com.Parameters("param&quot=CDATE("3/11/1999&quot