SOLID Server
Programmer's Guide and Reference

• WELCOME
  • This Guide
  • Audience
  • Document Conventions
  • Other Solid Documentation
  • Where to Find Additional Information
• THEORY OF OPERATION
  • SOLID SQL API
  • SOLID SQL API and ODBC Interface
  • ODBC History
  • ODBC Interface
  • ODBC Components
  • Matching an Application to a Driver
• A SHORT HISTORY OF SQL
  • SQL Background Information
  • ANSI 1989 Standard
• GUIDELINES FOR CALLING FUNCTIONS
  • General Information
  • Determining Driver Conformance Levels
  • Using the Driver Manager
  • Calling ODBC Functions
• BASIC APPLICATION STEPS
• CONNECTING TO A DATA SOURCE
  • About Data Sources
  • Initializing the ODBC Environment
  • Allocating a Connection Handle
  • Connecting to a Data Source
  • ODBC Extensions for Connections
• EXECUTING SQL STATEMENTS
  • Allocating a Statement Handle
  • Executing an SQL Statement
  • Setting Parameter Values
  • Performing Transactions
  • ODBC Extensions for SQL Statements
• RETRIEVING RESULTS
  • Assigning Storage for Results (Binding)
  • Determining the Characteristics of a Result Set
  • Fetching Result Data
  • Using Cursors
  • ODBC Extensions for Results
• RETRIEVING STATUS AND ERROR INFORMATION
  • Function Return Codes
  • Retrieving Error Messages
  • ODBC Error Messages
  • Processing Error Messages
• TERMINATING TRANSACTIONS AND CONNECTIONS
  • Terminating Statement Processing
  • Terminating Transactions
  • Terminating Connections
• CONSTRUCTING AN APPLICATION
  • Sample Application Code
  • Testing and Debugging an Application
  • Installing and Configuring ODBC Software
• USING SOLID SERVER
  • Stored Procedures
  • Event Alerts
  • Sequencer Objects
• FUNCTION SUMMARY
  • How to Read the Tables
  • Connecting to a Data Source
  • Obtaining Information about a Driver and Data Source
  • Setting and Retrieving Driver Options
  • Preparing SQL Requests
  • Submitting Requests
  • Retrieving Results and Information about Results
  • Obtaing Information about System Tables
  • Terminating a Statement
  • Terminating a Connection
• FUNCTION REFERENCE
  • Function Descriptions
  • Arguments
  • SOLID SQL API Include Files
  • ODBC Include Files
  • Diagnostics
  • Tables and Views
  • Catalog Functions
  • Search Pattern Arguments
  • SQLAllocConnect (ODBC 1.0, Core)
  • SQLAllocEnv (ODBC 1.0, Core)
  • SQLAllocStmt (ODBC 1.0, Core)
  • SQLBindCol (ODBC 1.0, Core)
  • SQLBindParameter (ODBC 2.0, Level 1)
  • SQLBrowseConnect (ODBC 1.0, Level 2)
  • SQLCancel (ODBC 1.0, Core)
  • SQLColAttributes (ODBC 1.0, Core)
  • SQLColumnPrivileges (ODBC 1.0, Level 2)
  • SQLColumns (ODBC 1.0, Level 1)
  • SQLConnect (ODBC 1.0, Core)
  • SQLDataSources (ODBC 1.0, Level 2)
  • SQLDescribeCol (ODBC 1.0, Core)
  • SQLDescribeParam (ODBC 1.0, Level 2)
  • SQLDisconnect (ODBC 1.0, Core)
  • SQLDriverConnect (ODBC 1.0, Level 1)
  • SQLDrivers (ODBC 2.0, Level 2)
  • SQLError (ODBC 1.0, Core)
  • SQLExecDirect (ODBC 1.0, Core)
  • SQLExecute (ODBC 1.0, Core)
  • SQLExtendedFetch (ODBC 1.0, Level 2)
  • SQLFetch (ODBC 1.0, Core)
  • SQLFetchPrev (SOLID Extension)
  • SQLForeignKeys (ODBC 1.0, Level 2)
  • SQLFreeConnect (ODBC 1.0, Core)
  • SQLFreeEnv (ODBC 1.0, Core)
  • SQLFreeStmt (ODBC 1.0, Core)
  • SQLGetConnectOption (ODBC 1.0, Level 1)
  • SQLGetCursorName (ODBC 1.0, Core)
  • SQLGetData (ODBC 1.0, Level 1)
  • SQLGetFunctions (ODBC 1.0, Level 1)
  • SQLGetInfo (ODBC 1.0, Level 1)
  • SQLGetStmtOption (ODBC 1.0, Level 1)
  • SQLGetTypeInfo (ODBC 1.0, Level 1)
  • SQLMoreResults (ODBC 1.0, Level 2)
  • SQLNativeSql (ODBC 1.0, Level 2)
  • SQLNumParams (ODBC 1.0, Level 2)
  • SQLNumResultCols (ODBC 1.0, Core)
  • SQLParamData (ODBC 1.0, Level 1)
  • SQLParamOptions (ODBC 1.0, Level 2)
  • SQLPrepare (ODBC 1.0, Core)
  • SQLPrimaryKeys (ODBC 1.0, Level 2)
  • SQLProcedureColumns (ODBC 1.0, Level 2)
  • SQLProcedures (ODBC 1.0, Level 2)
  • SQLPutData (ODBC 1.0, Level 1)
  • SQLRowCount (ODBC 1.0, Core)
  • SQLSetConnectOption (ODBC 1.0, Level 1)
  • SQLSetCursorName (ODBC 1.0, Core)
  • SQLSetParam (ODBC 1.0, Deprecated)
  • SQLSetPos (ODBC 1.0, Level 2)
  • SQLSetScrollOptions (ODBC 1.0, Level 2)
  • SQLSetStmtOption (ODBC 1.0, Level 1)
  • SQLSpecialColumns (ODBC 1.0, Level 1)
  • SQLStatistics (ODBC 1.0, Level 1)
  • SQLTablePrivileges (ODBC 1.0, Level 2)
  • SQLTables (ODBC 1.0, Level 1)
  • SQLTransact (ODBC 1.0, Core)
• APPENDIX A ERROR CODES
• APPENDIX B ODBC STATE TRANSITION TABLES
  • Environment Transitions
  • Connection Transitions
  • Statement Transitions
• APPENDIX C SQL GRAMMAR
  • SQL Statements
  • Elements Used in SQL Statements
• APPENDIX D DATA TYPES
  • SQL Data Types
  • C Data Types
  • ODBC 1.0 C Data Types
  • Default C Data Types
  • Transferring Data in its Binary Form
  • Precision, Scale, Length, and Display Size
  • Converting Data from SQL to C Data Types
  • Converting Data from C to SQL Data Types
• APPENDIX E COMPARISON BETWEEN EMBEDDED SQL AND ODBC
  • ODBC to Embedded SQL
  • Embedded SQL to ODBC
• APPENDIX F SCALAR FUNCTIONS
  • String Functions
  • Numeric Functions
  • Time and Date Functions
  • System Functions
  • Explicit Data Type Conversion