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