Cursor type should be: rdOpenForwardOnly.  LockType should be: rdConcurReadOnly.  RowsetSize should be: 1 (Error 40080).

For this type of operation, you must use a "cursor-less" result set. By setting the OpenResultset options as shown, RDO creates a cursor-less result set.