>Hi All, is it possible to execute a VFP SP using a OleDbCommand.ExecuteReader() command - which will return a DataReader object ?
>
>

>*-- My SP
>
>Procedure GetData()
>Select x from mytable
>EndProc
>
>

Don't know if it will work for you but I've done this using SETRESULTSET() in the VFP SP and using an OleDbDataAdapter in .NET. e.g .NET code:

        OleDbDataAdapter Da = new OleDbDataAdapter();
        Da.MissingSchemaAction = MissingSchemaAction.AddWithKey;
            Da.SelectCommand = (OleDbCommand) oConn.CreateCommand();
            Da.SelectCommand.CommandType = CommandType.StoredProcedure;
            Da.SelectCommand.CommandText = "SelectPostCodes";

            Da.SelectCommand.Parameters.AddWithValue("@a", lcInCode);
            Da.SelectCommand.Parameters.AddWithValue("@a", lcOutCode);

            Da.Fill(DSAddresses, "Addresses");

HTH,
Viv