What command do you execute? Do you have

OleDbReader myReader = objCmd.ExecuteReader();

Or you use another command?

>I get
>
>

>No value give for one or more parameters.
>

>
>>One other thing. Try changing your command to the following syntax:
>>
>>

>>OleDbCommand objCmd = new OleDbCommand("select * from customers where CustomerID = (?)");
>>objCmd.Parameters.Add("@myParam", "ALFKI");
>>

>>
>>Note that you don't need the "myParam" in the SQL Select.
>>
>>HTH.
>>
>>>I tried:
>>>

>>>OleDbCommand objCmd = new OleDbCommand("select * from customers where CustomerID = ?myParam");
>>>objCmd.Parameters.Add("@myParam", "ALFKI");
>>>

>>>
>>>gives me
>>>
>>>

>>>Command contains unrecognized phrase/keyword.
>>>

>>>
>>>and
>>>
>>>

>>>OleDbCommand objCmd = new OleDbCommand("select * from customers where CustomerID = ?myParam");
>>>objCmd.Parameters.Add("@myParam", "ALFKI");
>>>

>>>
>>>gives me
>>>
>>>

>>>Missing operand.
>>>

>>>>I think you are missing "@" in your syntax. I think it should be
>>>>
>>>>

>>>>objCmd.Parameters.Add("@CustomerID", "ALFKI");
>>>>

>>>>
>>>>HTH.
>>>>
>>>>>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?