I have a stored procedure in a VFP DBC that accepts a integer parameter. In .NET I can call this stored procedure if I hard code the parameter value in the CommandText property. But if I try to use the Command.Parameters collection to pass the parameter it fails.

Here's the working code:

OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "EmployeeSalesByEmployee(5)";
** execute the stored procedure **

Here's the non-working code:

OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "EmployeeSalesByEmployee(?)";
OleDbParameter param = new OleDbParameter("", 5);
cmd.Parameters.Add(param);
** execute the stored procedure **

This code fails with an OleDbException with a message of "Syntax Error".

Anybody know why this second technique does not work?