Name the four different cursor and locking types in ADO and describe them briefly ?
CURSORS:: ********* The cursor types are listed from least to most resource intensive. Forward Only – Fastest, can only move forward in recordset Static – Can move to any record in the recordset. Data is static and never changes. KeySet – Changes are detectable, records that are deleted by other users are unavailable, and records created by other users are not detected Dynamic – All changes are visible. LOCKING TYPES:: **************** LockPessimistic – Locks the row once after any edits occur. LockOptimistic – Locks the row only when Update is called. LockBatchOptimistic – Allows Batch Updates. LockReadOnly – Read only. Cannot alter the data. Name the different compatibility types when creating a COM component.
