You can use SET statements in ADO.NET. I would check your VFP code to make sure it is working correctly. Run the stored procedure followed by your select statement in a prg.

>Dear ut-user,
>
>I would like to know if it is possible to run VFP set statements (set exact on, set ansi on) via the ADO.NET command object. I have made an attempt, but no luck, alas.
>
>What am I doing wrong here?
>
>myCon.ConnectionString = CFH.getConnectionString(); // external helper.
>string sql = "runsetstatements()"; // vfp storedproc that executes.
>OleDbCommand myCom = new OleDbCommand(sql,myCon);
>myCon.Open();
>myCom.ExecuteNonQuery();
>sql = "SELECT * FROM zorglevr WHERE zoeknaam='B'";
>myCom.CommandText = sql;
>myRdr = myCom.ExecuteReader(CommandBehavior.CloseConnection);
>
>The reader keeps returning results that it shouldn't accourding to the set statements. Perhaps, my approach is just totally wrong.
>
>Thanks for giving attention to my problem.