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.