Thanks to all of you for your replies. I found my problem and it was ME!
In my data service I was creating a new command object but did not duplicate the parameters collection. DUH!
>Hi Dan,
>
>I tried your code and for me it worked fine.
>Are you using the latest version of the VFP Ole DB Provider?
>
>>I'm using the VFPOLEDB provider and I am creating a command object like this:
>>
>>
>>OleDbCommand objCmd = new OleDbCommand("select * from customers where CustomerID = ?");
>>objCmd.Parameters.Add("CustomerID", "ALFKI");
>>
>>
>>When I execute this command I am getting an OleDbException that says:
>>
>>
>>No value given for one or more required parameters.
>>
>>
>>How do I use the parameter collection to pass parementers to commands?