CSE :: Database System 2 - CS
- ODBC provides an interface by which Web server programs can access and process relational data sources in a DBMS-independent manner.
- The process of defining a system data source name involves specifying the type of driver and the identity of the database to be processed.
- ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.
- OLE DB has two types of data providers: tabular data providers and service providers.
- The driver manager processes ODBC requests and submits specific SQL statements to a given type of data source.
- ADO overlies the more complex OLE DB model, and can be called for scripting languages but not programming languages.