I'm trying to use a prepared statement to call a stored procedure (using ADODB with classic ASP), but when I set CommandType I get the following error:

> 
> ADODB.Command error '800a0bb9'
> 
> 
> Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. 
> 
> 
> 

I have the following code:

```vb
With Server.CreateObject("ADODB.Command")
    .ActiveConnection = db 'this is initialized prior
    .CommandType = adCmdStoredProc
    .CommandText = "procName"
End With

```

The prepared statement name is correct (I'm able to call it just by executing the string), and if I leave out the .CommandType and try calling .Execute, I get an error specifying: 

> 
> Procedure or function 'procName' expects parameter '@ParamName', which was not supplied.
> 
> 
> 

Even if I leave out the CommandType, I have no idea how to actually add the parameter (something along the following lines just results in the original error about arguments of the wrong type):

```vb
.Parameters.Append .CreateParameter("@ParamName",adVarChar,adParamInput,50,param)

```

I've also tried the following and got an error "Item cannot be found in the collection corresponding to the requested name or ordinal."

```vb
.Parameters.Refresh
.Parameters(0) = param

```

I've looked at several examples of how to call stored procedures using prepared statements, and it looks like I'm using the right syntax, but anything I try seems to result in some kind of error. Any help would be greatly appreciated.