ODBC, OLE DB, ADO, and ASP Questions

• The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.
• An OLE DB interface is specified by a set of objects and the properties and methods that they expose.
• A data source is an ODBC data structure that identifies a database and the DBMS that processes it.
• OLE DB tabular data providers present data in the form of rowsets.
• A user data source is one that can be shared among database users.
• A OLE DB rowset is an abstraction of a relation, which in turn is an abstraction of a recordset.
• ODBC identifies two types of drivers: single tier and multiple-tier.
• ODBC is a foundation of data access in the specifically Microsoft world.
• ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.
• The ADO connection object is created after the ADO errors object is created.
• An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.
• Users of OLE DB functionality are referred to as data providers.
• A file data source is one that is local to a single computer.
• A OLE DB collection is an object that contains a group of other objects.
• An OLE DB rowset is equivalent to a cursor.
• OLE DB has two types of data providers: tabular data providers and service providers.
• An abstraction is a generalization of something.
• ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.
• The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed.
• ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.