Calling sproc with parameters with ADODB

grahamor

Hi,

I am trying to call a stored procedure with ASP JSCRIPT and pass in 1 parameter:

var cn = Server.CreateObject("ADODB.Connection");
    var cmd = Server.CreateObject("ADODB.Command");
    cn.Open ("DSN=xxx;UID=xx;PWD=xx;INITIAL CATALOG=xxx");
    cmd.ActiveConnection = cn;
    
    cmd.CommandText = "sproc name";
    cmd.CommandType = 4;
    
    cmd.Parameters.Refresh
    cmd.Parameters(1).Value = 'test value'
    
    cmd.Execute();

If i add a parameter with data length, direction etc it works but i need to only specify the param name and the value

The error i am getting is :

ADODB.Command error '800a0cc1' 

Item cannot be found in the collection corresponding to the requested name or ordinal.

Anyone any ideas ??

Thanks

nialo

Think the parameter should start at zero not 1.

cmd.Parameters(0)