I can't get a scrollable(can fetch backward and can fetch foreward) cursor after an ITransation::Commit(...).I am executing a store procedure using CCommand object from OLEDB and I have set properties DBPROP_COMMITPRESERVE, DBPROP_CANFETCHBACKWARDS, DBPROP_CANSCROLLBACKWARDS for rerecordset. If I don't set any properties(I let it default) for recordset, when I open the command, after commit transaction recordset is valid but is forewardonly

Tx a lot.