>>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