以下示例显示了我们遇到的问题.

var c = new ADODB.Connection();
var cmd = new ADODB.Command();
var rs = new ADODB.Recordset();
object recordsAffected;
 
c.Open("Provider=sqlOLEDB;Server=*****;Database=*****;User Id=*****;Password=*****;");
 
cmd.ActiveConnection = c;
cmd.CommandType = ADODB.CommandTypeEnum.adCmdText;
cmd.CommandText = "create table testing2008 (id int)";
cmd.Execute(out recordsAffected);
 
try {
    cmd.CommandText = "select * from testing2008 union select * from testing2008";
 
    rs.CursorLocation = ADODB.CursorLocationEnum.adUseClient;
    rs.Open(cmd,Type.Missing,ADODB.CursorTypeEnum.adOpenDynamic,ADODB.LockTypeEnum.adLockBatchOptimistic,-1);
 
    rs.AddNew();
    rs.Fields["id"].Value = 0; //throws exception
    rs.Save();
}
catch (Exception ex) {
    MessageBox.Show(ex.ToString());
}
finally {
    cmd.CommandText = "drop table testing2008";
    cmd.Execute(out recordsAffected);
    c.Close();
}