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