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
Using the ODBC Client
Windows
odbcgen
failover
localodbcgen
slkgeneral