>Hi all, I'm trying to call a SQL Server stored procedure as a method of the connection object using ADO. I've modified the code in
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdconstoredprocasmethodonconnection.asp
>
>to satisfay my needs but I'm having problems passing more than one parameter at a time. Here's the code I'm using to pass the parameters
>
>

> Dimension arParameters(2)
> arParameters(1)='1'
> arParameters(2)='1'
> orsResults=oConnection.Execute(@arParameters)
>

>
>but I'm getting an error message saying the second parameter has not been specified. I've tried this code with a procedure that only needs one parameter and it works.
>
>Any help is appreciated!
>
>EGB
>

does it really need an array ?
why not

lcparms = '1,1'
orsResults = oConnection.Execute(?lcparms) 

lemme know if that works.
mondo regards [Bill]