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.