The ODBC Solution: Open Database Connectivity in Distributed EnvironmentsNow you can learn how to tap the power of open systems quickly and easily! This practical book/disk package gives you everything you need to write consistent applications that communicate readily with any ODBC data source in a client/server environment. In a hands-on tutorial format with extensive examples, this easy-to-use guide shows you exactly how to use all ODBC features to maximize connected database functionality. This is the first book to cover ODBC in such depth - you'll find all the tools and techniques you need to achieve true open connectivity across a wide array of platforms and products. You'll learn how to reach different data sources, how to maximize the functionality of every connected database, and all the proven techniques you need to become a proficient ODBC programmer. The accompanying disk contains all of the source code in C, which makes ODBC applications easy to create. With the tutorial and the disk, you can create a full-featured database application for Windows, UNIX, Macintosh, or OS/2 that can reach any ODBC data source. |
Contents
An Introductory History of SQL and the Call Level Interfaces | 1 |
The Structure of ODBC | 7 |
7 | 34 |
Copyright | |
13 other sections not shown
Common terms and phrases
allocated application BIGTABLE bitmask Block cursors BOOL bStatus buffer call SQLGetInfo catalog functions cbValueMax clause column name connection handle contains CREATE TABLE statement cursor name data source supports database dBASE DBMS DELETE statements descriptor driver supports Error Description Returned executed Explanation and examples fetch fInfoType hdbc henv hstmt HSTMT hstmt irow isolation level length NULL number of bytes number of rows ODBC functions option owner name parameter marker ppszCreateStatement query result set RETCODE RETCODE_IS_SUCCESSFUL rc retrieve returns SQL_ERROR rgbValue rowset SELECT sizeof specified SQL data type SQL statement SQL type SQL_BIGINT SQL_C_BINARY SQL_C_CHAR SQL_C_SLONG SQL_C_SSHORT SQL_C_STINYINT SQL_DECIMAL SQL_DOUBLE SQL_ERROR SQL_INVALID_HANDLE SQL_FLOAT SQL_INVALID_HANDLE The SQLSTATE SQL_NTS SQL_NUMERIC SQL_REAL SQL_SUCCESS SQL_SUCCESS_WITH_INFO SQLBindCol SQLBindParameter SQLColAttributes SQLColumns SQLConnect SQLDescribeCol SQLDriverConnect SQLExec SQLExecDirect SQLExecute SQLExtendedFetch SQLFetch SQLFreeStmt SQLGetData SQLGetInfo SQLGetTypeInfo SQLNumResultCols SQLParamData SQLPrepare SQLPutData SQLSetPos SQLSTATE return codes SQLStatistics SQLTables statement handle strcpy SWORD syntax table name transaction TypeInfo UCHAR UPDATE UWORD