I'm writing a form with a DataGrid and an ADODC to allow users to update Oracle database tables. These tables are relational lookup tables, but you can update them without violating referential integrity.

I set the ADODC to connect to Oracle via ODBC. I can get the Oracle table records into the DataGrid without a problem. However, if I update a field or add a new record, I get the subject line as an error message. I suppose I'm not providing Oracle or ADODC without something it needs, but I don't know what.

Selected properties are:

CursorLocation: adUseClient
CursorType: adOpenStatic
LockType: adLockOptimistic
Mode: adModeReadWrite

Thanks.