SQL Server with VB and ADO

[Don Bryson]

The ADO Command Object has a collection of Parameter objects.
All parameter objects added to the Command paramaters collection are passed to the stored
procedure when the execute method of the command object is "run".
These parameters are passed to the procedure in the same order they are added to the
paramater collection. I need a way of sending the ado paramaters to specific stored
procedure parameters. An example below

Create Procedure Test
@inArg1 int = 1,
@inArg2 int = 2,
@inArg3 int = 3
AS

<
BODY of procedure
>
End Procedure

How using the Paramaters collectionof the command object can I pass a parameter to
JUST inArg2. If I define two paramaters then inArg1, and inArg2 will get values. If I
define one parameter then inArg1 only will get a value. I have no way of doing this in
ADO:

execute test inArg2 = 9;

please e-mail with help!

Thanks,
Don Bryson
Consultant
Icon Solutions
donb@iconsolutions.com

[Brad]