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