>>>Below's runnable sample code that shows how to call VFP SP with 2 date type parameters
>
><snip>
>
>The same for one character parameter

>>>oCmd.CommandText = [CustOrdersOrders(?)]
>>>lcCustomerID = "TOMSP"
>>>oPar = oCmd.CreateParameter(lcCustomerID, ;
>>>		adVarChar, adParamInput, LEN(lcCustomerID), lcCustomerID)
>>>oCmd.Parameters.Append(oPar)
>>>oRs = oCmd.Execute()
>>>

>>
>>Can you return VFP cursor using this approach?
>
>See Re: CursorAdapters and existing ADO recordsets Message #824438

I see. Also I guess I can just do

oConn.Execute('MySp('+transform(par1)+"," + transform(par2)+()') to retrieve my record set.