Difficulty: Easy
Correct Answer: ADO
Explanation:
Introduction / Context:
OLE DB is a low-level COM-based data access technology. Many developers prefer a simpler abstraction for rapid application development, scripting, and language interoperability—this is where ADO (ActiveX Data Objects) became popular.
Given Data / Assumptions:
Concept / Approach:
ADO wraps OLE DB to expose Recordset, Command, and Connection objects that are straightforward to use from VB, VBScript, and other COM-aware languages. It hides much of the provider-specific plumbing while still allowing access to relational and non-relational sources through OLE DB providers.
Step-by-Step Solution:
Verification / Alternative check:
Documentation from Microsoft positions ADO as a high-level interface over OLE DB providers, emphasizing ease of use.
Why Other Options Are Wrong:
Common Pitfalls:
Final Answer:
ADO
Discussion & Comments