With the current VFP OleDb provider you cannot use the full command object functionality. Instead you need to pass parameters by creating literal strings of the Store Proc command:

OleDbCommand oCommand = new OleDbCommand();
oCommand.Connection = this.oConn;
oCommand.CommandText = "Test('Salut')";

The problem here is that returning values doesn't work. This will be fixed in the next version of the OleDb driver...

+++ Rick ---


>Hi Guys,
>
>I want to call a vfp store procedure with parameter and it always give me a ole exception code...
>
>Thank's for your help.
>
>That's the code i try. Do you saw something Wrong...
>
>

>OleDbConnection oCon = new OleDbConnection(@"provider=vfpoledb;data source=C:\Devellopement\Data\Video.dbc");
>			
>OleDbCommand poCmd = new OleDbCommand();
>poCmd.Connection = oCon;
>poCmd.CommandText = "[test]";
>poCmd.CommandType = CommandType.StoredProcedure;
>
>OleDbParameter x = new OleDbParameter("@psParam",OleDbType.VarChar);
>x.Value = "Salut";
>poCmd.Parameters.Add(x);
>			
>poCmd.Connection.Open();
>string y  = poCmd.ExecuteScalar().ToString();
>

>
>Vfp SP code...
>
>

>PROCEDURE Test(psParam as String) as String
>	RETURN psParam
>ENDPROC
>