Chapter 11 Accessing the Database Server ODBC OLE
Chapter 11 Accessing the Database Server: ODBC, OLE DB, and ADO
Typical Web Server Page 340
Chapter 11 ODBC Open Database Connectivity; DBMS-independent means for processing relational database data – ORACLE – SYBASE – INFORMIX Page 342
Role of ODBC Standard Page 340
Chapter 11 ODBC Terminology • Data source the database, its associated DBMS, operating system, and network platform • Driver manager intermediary between the application and DBMS drivers • Driver processes ODBC requests and submits SQL statements to a data source Page 343
ODBC Architecture Page 343
Chapter 11 Conformance Levels • ODBC concerned with API application program interface • SQL – Minimum – Core – Extended Page 344
Chapter 11 ODBC Data Source Types • File shared among database users • System local to a single computer • User only available to the user who created it Page 346
Chapter 11 OLE DB Object Linking and Embedding Database; Provides an object-oriented interface to data of almost any type and used as an interface to ODBC and nonrelational data Page 348
Chapter 11 Object Terminology • Abstraction a generalization of something • Method actions that an object can perform • Property a characteristic of a recordset abstraction • Collection object that contains a group of other objects Page 348
Role of OLE DB Page 341
OLE DB Goals Page 349
OLE DB Data Providers Page 350
Chapter 11 ADO Active. X Data Objects; an interface that enables programmers in almost any language (including scripting) to access OLE DB functionality Page 351
Role of ADO Page 342
ADO Object Model Page 352
- Slides: 16