Inside ODBCOpen Database Connectivity (ODBC) is a standard API for accessing information from different data storage formats and programming interfaces. Support for ODBC is not limited to Microsoft; it's now an industry standard that nearly all DBMS vendors and major independent software vendors support. Inside ODBC, written by the architect of ODBC, Kyle Geiger, dispels the confusion about this technology by explaining its design, its architecture, and some of its history. Important considerations for the next release of ODBC - version 3.0 - are also covered. This is truly the inside story of ODBC, the key ingredient of next-generation client/server computing. For technical managers in corporate information systems groups, developers of ODBC-enabled drivers and applications, those involved in the process of downsizing from mainframes to distributed client/server computing, and database users who have heard of ODBC but don't really understand it, this book is essential reading. |
Contents
INSIDE ODBC | 3 |
the Development Tool Developers Perspective | 11 |
CHAPTER | 23 |
Copyright | |
8 other sections not shown
Common terms and phrases
application program architecture array benchmark bytes call level interface char client client/server column connection handle cursor data protocol data source name data types database API dBASE DBMS DBMS vendors DBMSs delete descriptor desktop database dialog box display Driver Manager dynamic SQL embedded SQL error example EXEC SQL executed fetch file server function call hdbc hstmt hwnd Integer ISAM keyset lock Microsoft Access Microsoft SQL Server multiple NULL ODBC function ODBC's OLE Automation options Oracle output parameters pCopy precompiler query results set retrieve return value row-wise binding rowset runtime scroll SELECT statement SERIALIZABLE shown in Figure specified SQL Access Group SQL statement SQL string SQL_C_CHAR SQL_NTS SQLBindCol SQLBindParameter SQLDriverConnect SQLExec Direct SQLExtendedFetch SQLFetch SQLGetData statement handle static SQL stored procedure syntax table name Text driver tion transaction update user interface variable Visual Basic Windows Windows 95 X/Open