•  Using the ODBC Client
  •  About the ODBC Client
    • About the Client/Server Configuration
    • About the Local Configuration
    • About DataDirect Connection Pooling
    • About DataDirect Bulk Load
  • Using the ODBC Administrator
  •  Configuring Data Sources for the ODBC Client on Windows
    • Configuring ODBC User and System Client Data Sources
    • Configuring ODBC File Client Data Sources
    •  ODBC Connection Dialogs
      • Stage 1: Establishing a Network Connection
      • Stage 2: OpenAccess SDK Server Authentication
      • Stage 3: Data Source Logon
      • Testing ODBC Connections on Windows
  •  Configuring Data Sources for the Local ODBC Client on Windows
    • Configuring ODBC User and System Client Data Sources
    • Configuring ODBC File Client Data Sources
    • ODBC Connection Dialogs
    • Testing ODBC Connections on Windows
  •  Configuring ODBC Client Data Sources on Linux and UNIX
    • Configuring the System Information File
    • Example: odbc.ini for Solaris
    • Example: odbc64.ini for Solaris
    • Setting Environment Variables
    • Using a Centralized System Information File
  •  Configuring Local ODBC Client Data Sources on Linux and UNIX
    • Configuring System Information Files
    • Example: odbc.ini for Solaris
    • Example: odbc64.ini for Solaris
    • Setting Environment Variables
    • Using a Centralized System Information File
  •  Connecting Using a Connection String
    • DSN-less Connections in Linux and UNIX
  •  Specifying ODBC Connection Attributes
    • Alternate Servers
    • ApplicationID
    • ApplicationName
    • AutomaticApplicationID
    • BlockFetchForUpdate
    • BulkBinaryThreshold
    • BulkCharacterThreshold
    • BulkLoadBatchSize
    • ConnectionReset
    • Connection Retry Count
    • Connection Retry Delay
    • CryptoProtocolVersion
    • Custom Properties
    • Data Source Name
    • Database
    • DBLogonID
    • DBPassword
    • DescribeVarcharAsLongvarchar
    • DescribeWcharAsChar
    • Description
    • Distinguished Name
    • DriverCompletion
    • DSN
    • EnableDescribeParam
    • Encrypted (SSL)
    • FetchNextOnly
    • FixCharTrim
    • Force SQL_DRIVER_NOPROMPT
    • GetOutputParams (GOP)
    • HLogonID
    • HPassword
    • Hostname In Certificate
    • IANAAppCodePage
    • LDAP Server Host
    • LDAP Server Port
    • LimitCursorColumnsize
    • LimitParameterBindSize
    • LoadBalanceTimeout
    • Load Balancing
    • LogonID
    • MaxPoolSize
    • MinPoolSize
    • MSAccessWorkaroundCreateParams
    • NewPassword
    • Password
    • Pooling
    • Service Data Source
    • Service Host
    • Service Port
    • SessionConnectTimeout
    • SLKStaticCursorLongColBuffLen
    • TransliterationWorkAroundServer
    • Truststore
    • Truststore Password
    • Use LDAP
    • UID (LogonID)
    • Validate Server Certificate
    • WorkArounds (WA)
    • WorkArounds2
  •  Configuring Connection Failover
    • Connection Failover Attributes
  • Using Client Load Balancing
  • Using Connection Retry
  •  Using SSL Encryption
    • SSL Server Authentication
    • Certificates
    • SSL Cipher Suites
    • Summary: Encryption-Related Attributes
  •  Using DataDirect Connection Pooling
    • Creating a Connection Pool
    • Adding Connections to a Pool
    • Removing Connections from a Pool
    • Handling Dead Connections in a Pool
    • Connection Pool Statistics
    • Summary of Pooling Related Connection Attributes
  •  Using DataDirect Bulk Load
    • Configuring DataDirect Bulk Load
    • Exporting Data from a Database
    •  The Bulk Load Configuration File
      • Bulk Load Configuration File Schema
      • Verification of the Bulk Load Configuration File
    • Sample Applications
    • Character Set Conversions
    • External Overflow Files
    • Bulk Load Connection Attributes
    •  DataDirect Bulk Load Functions
      • Utility Functions
      • Export, Validate, and Load Functions
    •  DataDirect Bulk Load Statement Attributes
      • SQL_BULK_EXPORT_PARAMS
      • SQL_BULK_EXPORT
  •  Connecting Using Saved Login Information
    • On Windows
    • On UNIX/Linux
  • Interactive SQL for ODBC
  • ODBC OpenAccess SDK Driver Setup Dialog Box
•  Developing ODBC Applications
  • Required ODBC Libraries and Header Files
  • Compiler Requirements
  •  ODBC API Functions
    • Binding SQL Statements
    • Support for Unicode ODBC W (Wide) Function Calls
  • SQL Escape Sequences
  • Data Types
  • Isolation Levels
  •  Threading
    • Threading Architecture
    • Cancelling Functions in Multithreaded Applications
  •  Using Scrollable Cursors
    • Using Static Scrollable Cursors
    • Using Keyset-Driven Scrollable Cursors
  • Using Stored Procedures
  •  Specifying Application IDs
    • Specifying Application IDs Explicitly
    • Generating Application IDs Automatically
  • Sending Arrays of Parameters
  • Persisting a Result Set as an XML Data File
  •  Error Handling
    • Driver Errors
    • ODBC Client Errors
    • OpenAccess SDK Server Errors
    • OpenAccess SDK SQL Engine Errors
    • Data Source Errors
  •  Developing Performance-Optimized ODBC Applications
    • Catalog Functions
    • Minimizing the Use of Catalog Functions
    •  Avoiding Search Patterns
      • Determining Table Characteristics with a Dummy Query
      • Managing the Retrieval of Database Meta-Information
    •  Retrieving Data
      • Retrieving Long Data
      • Reducing the Size of Retrieved Data
      • Using Bound Columns
      • Using SQLExtendedFetch Instead of SQLFetch
      • Choosing the Right Data Type
    •  Selecting ODBC Functions
      • Using SQLPrepare/SQLExecute and SQLExecDirect
      • Using Arrays of Parameters
      • Using SQLPrepare and Multiple SQLExecute Calls
      • Using the Cursor Library
    •  Managing Connections and Updates
      • Managing Connections
      • Managing Commits in Transactions
      • Using Positional Updates and Deletes
      • Using SQLSpecialColumns
•  SQL Escape Sequences
  • Date, Time, and Timestamp Escape Sequences
  •  Scalar Functions
    • String Functions
    • Numeric Functions
    • Date and Time Functions
    • System Functions
  • User-Defined Functions
  • Like Predicate Escape Characters
  • Outer Join Escape Sequences
  • Procedure Call Escape Sequences
•  Data Types Supported
  •  Supported Data Types
    • ODBC Client
•  Developing ODBC Applications for Internationalization
  •  Unicode and Non-Unicode ODBC Drivers
    •  Function Calls
      • Unicode Application with the OpenAccess SDK ODBC Driver
      • Non-Unicode Application with the OpenAccess SDK ODBC Driver
    • Data
  •  Developing ODBC Applications on Linux/UNIX
    • Using Double-Byte Character Sets on Linux/UNIX
    • Using UTF-16 for your Applications on Linux/UNIX
  • The Driver Manager on Linux/UNIX
  •  Values for IANAAppCodePage Connection String Attribute
    • Solaris
    • HP-UX
    •  AIX
      • Linux
      • Windows