•  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
•  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
•  Using the ADO Client
  • About the ADO Client
  • Using the Configuration Manager
  •  Configuring ADO Client Data Sources
    • Creating an ADO Client Data Source
    • Modifying an ADO Client Data Source
    • Deleting an ADO Client Data Source
    • Changing Data Source Directories
  •  Connecting to an ADO Client
    • Testing ADO Connections
    •  Specifying ADO Connections with the Configuration Manager
      • Stage 1: Establishing a Network Connection
      • Stage 2: OpenAccess SDK Server Authentication
      • Stage 3: Data Store Logon
    • Connecting with a Provider String
  •  ADO Connection Attributes
    • Alternate Servers
    • Application ID
    • Application Name
    • Automatic Application ID
    • Connection Retry Count
    • Connection Retry Delay
    • Custom Properties
    • Database
    • Data Source Name
    • DBLogonID
    • DBPassword
    • Default Length for Long Data
    • DescribeWcharAsChar
    • DescribeVarcharAsLongvarchar
    • Description
    • Distinguished Name
    • Driver Compatibility
    • Encrypted (SSL)
    • Force SQL_DRIVER_NOPROMPT
    • Host
    • Host Password
    • Host User Name
    • Hostname In Certificate
    • Load Balancing
    • New Password
    • Password
    • Port
    • Server Data Source
    • Service Data Source
    • Service Host
    • Service Port
    • Truststore
    • TrustStore Password
    • Use LDAP
    • User ID
    • Validate Server Certificate
    • Defining Custom Properties
  •  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
•  Developing ADO Applications
  • OLE DB Objects and Interfaces
  • Supported Schema Rowsets
  •  Supported OLE DB Property Groups
    •  Data Source Property Group
      • Data Source Information Property Group
    • Initialization Property Group
    • Rowset Property Group
    • Session Property Group
  • OLE DB Interfaces Supported in ADO
  •  Mapping ADO Methods and Properties
    • ADO Command Object
    • Connection Object
  • Data Shaping
  • Persisting Information
  • Using Rowsets
  • Mapping Data Types
  • Isolation Levels
  •  Specifying Application IDs
    • Specifying Application IDs Explicitly
    • Generating Application IDs Automatically
  •  Error Handling
    • ADO Data Provider Errors
    • OpenAccess SDK Client Errors
    • OpenAccess SDK Server Errors
    • OpenAccess SDK SQL Engine Errors
    • Data Source Errors
•  Using the JDBC Client
  •  About the JDBC Client
    • JDBC Client
    • DataDirect Spy
    • DataDirect Test
    • DataDirect Connection Pool Manager
    • DataDirect Bulk Load
    • J2EE Connector Architecture (JCA) Resource Adapter
  • Registering the JDBC Client
  • Specifying Driver Connection URLs
  •  Configuring JDBC Data Sources
    • Creating and Managing JDBC Data Sources
    • Calling a Data Source in an Application
    • Using JNDI for Naming Databases
    • Using Connection Pooling
  •  J2EE Connector Architecture Resource Adapter
    • Using the Resource Adapter with an Application Server
    • Using the Resource Adapter from an Application
  •  Specifying Connection Properties
    • Using Connection URLs or the JDBC Driver Manager
    • Using JDBC Data Sources
  •  JDBC Connection Properties
    • AllowPrefetch
    • AlternateServers
    • ApplicationName
    • BlockFetchForUpdate
    • CipherSuites
    • BulkLoadBatchSize
    • ConnectionRetryCount
    • ConnectionRetryDelay
    • ConvertNull
    • CryptoProtocolVersion
    • Custom Properties
    • Database
    • DBPassword
    • DBUser
    • Description
    • Encrypted
    • HostNameInCertificate
    • HPassword
    • HUser
    • InitializationString
    • InsensitiveResultSetBufferSize
    • JavaDoubleToString
    • JDBCBehavior
    • LoadBalancing
    • LongDataCacheSize
    • Password
    • PortNumber
    • QueryTimeout
    • ServerDataSource
    • ServerName
    • SLKStaticCursorLongColBuffLen
    • SpyAttributes
    • TCPKeepAlive
    • TrustStore
    • TrustStorePassword
    • User
    • ValidateServerCertificate
    • Defining Custom Properties
  • TCPKeepAlive Support
  • Configuring Connection Failover
  • Using Client Load Balancing
  • Using Connection Retry
  • Testing JDBC Connections
  •  Required Permissions for the Java 2 Platform
    • Permissions for Bulk Load from a CSV File
  •  Using SSL Encryption
    • SSL Server Authentication
    • Certificates
    • SSL Cipher Suites
    • Summary: Encryption-Related Properties
  •  Using DataDirect Bulk Load
    •  Using a DDBulkLoad Object
      • Exporting Data to a CSV File
      • Loading Data From a ResultSet Object
      • Loading Data From a CSV File
      • Permissions for Bulk Load from a CSV File
      • Logging
    •  Using CSV Files
      • Bulk Load Configuration File
      • Bulk Load Configuration File Schema
      • Character Set Conversions
      • External Overflow Files
      • Discard File
    • Bulk Load Connection Properties
    •  DataDirect Bulk Load Methods
      • DDBulkLoad Interface
  • Interactive SQL for JDBC
•  Using DataDirect Test
  •  DataDirect Test Tutorial
    • Configuring DataDirect Test
    • Starting DataDirect Test
    •  Connecting Using DataDirect Test
      • Connecting Using a Data Source
      • Connecting Using Driver/Database Selection
    • Executing a Simple Select Statement
    • Executing a Prepared Statement
    • Retrieving Database Metadata
    • Scrolling Through a Result Set
    • Batch Execution on a Prepared Statement
    • Returning ParameterMetaData
    • Establishing Savepoints
    •  Updatable Result Sets
      • Deleting a Row
      • Inserting a Row
      • Updating a Row
    • LOB Support
•  Tracking JDBC Calls
  • About DataDirect Spy
  •  Enabling DataDirect Spy
    • Using the JDBC Driver Manager
    • Using JDBC Data Sources
    • DataDirect Spy Attributes
  • Using DataDirect Spy with JDBC Data Sources
•  Developing JDBC Applications
  • JDBC 4.0 Support
  • JCA Resource Adapter Class
  •  SQL Support
    • Binding SQL Statements
  • Data Types
  • Isolation Levels
  •  Threading
    • Threading Architecture
    • Cancelling Functions in Multithreaded Applications
  •  Using Scrollable Cursors
    • Result Set Types
    • Concurrency Types
    • Using Scrollable Result Sets
  • Specifying Application IDs
  •  Parameter Metadata Support
    • INSERT and UPDATE Statements
    • Select Statements
  • ResultSet Metadata Support
  • Unicode Support
  • Rowset Support
  •  Error Handling
    • Driver Errors
    • OpenAccess SDK Server Errors
    • OpenAccess SDK SQL Engine Errors
    • Data Source Errors
  •  Fine-Tuning JDBC Application Performance
    •  Reducing Download Time
      • Reducing Download Time
    • Fetching BigDecimal Objects
    •  Using Database Metadata Methods
      • Minimizing the Use of Database Metadata Methods
      • Avoiding Search Patterns
    •  Retrieving Data
      • Returning Long Data
      • Reducing the Size of Data Retrieved
      • Choosing the Right Data Type
      • Using Parameter Markers as Arguments to Stored Procedures
      • Using the Statement Object instead of the PreparedStatement Object
      • Choosing the Right Cursor
    • Using get Methods Effectively
    •  Designing JDBC Applications
      • Managing Connections
      • Managing Commits in Transactions
    •  Updating Data
      • Using updateXXX Methods
      • Using getBestRowIdentifier()
•  Using the ADO.NET Client
  • About the ADO.NET Client
  •  Specifying Connection Options
    • Alternate Servers
    • Application ID
    • BlockFetchForUpdate
    • Certificate Store Location
    • Connection Reset
    • Connection Retry Count
    • Connection Retry Delay
    • Connection Timeout
    • CryptoProtocolVersion
    • CustomProperties
    • Database
    • DB Password
    • DB User
    • Enable Trace
    • EncryptionMethod
    • Host
    • Host Name In Certificate
    • Host Password
    • Host User
    • Load Balance Timeout
    • Load Balancing
    • Max Pool Size
    • Min Pool Size
    • New Password
    • Password
    • Parameter Mode
    • Persist Security Info
    • Pooling
    • Port
    • Schema Collection Timeout
    • Server Data Source
    • Trace File
    • User ID
    • Validate Server Certificate
    • Defining Custom Properties
  •  Using Connection Pooling
    • Creating a Connection Pool
    • Adding Connections to a Pool
    • Removing Connections from a Pool
    • Handling Dead Connection in a Pool
    • Tracking Connection Pool Performance
  • Using Connection Failover
  • Using Client Load Balancing
  • Using .NET Objects
  • Assemblies
  • Parameter Markers
  • Parameter Arrays
  • Stored Procedures
  • Transaction Support
  • Using the Data Providers in Visual Studio
  •  Adding Connections
    • Adding Connections in Server Explorer
    • Adding Connections with the Data Source Configuration Wizard
  •  Using Provider-specific Templates
    • Creating a New Project
    • Adding a Template to an Existing Project
  • Data Provider Integration Scenario
  • Connecting to a Data Source
  • SSL Support for the ADO.NET Client
•  Developing ADO.NET Applications
  • Namespace
  •  Data Types
    • Mapping Parameter Data Types
  • Isolation Levels
  • Threading
  • Event Handling
  •  Microsoft .NET Public Objects/Interfaces Supported
    • OpenAccessCommand Object
    • OpenAccessCommandBuilder Object
    • OpenAccessConnection Object
    • OpenAccessDataAdapter Object
    • OpenAccessDataReader Object
    • OpenAccessError Object
    • OpenAccessErrorCollection Object
    • OpenAccessException Object
    • OpenAccessInfoMessageEventArgs Object
    • OpenAccessParameter Object
    • OpenAccessTrace Object
    • OpenAccessTransaction Object
  •  Setting .NET Security Permissions
    • Code Access Permissions
    • Security Attributes
  •  Error Handling
    • Microsoft .NET Errors
    • ADO.NET Errors
    • OpenAccess SDK Server Errors
    • OpenAccess SDK SQL Engine Errors
    • Data Source Errors
  •  Diagnostic Support
    •  Tracing Method Calls
      • Using Environment Variables
      • Using Static Methods
    • PerfMon Support
  •  Designing .NET Applications for Performance
    •  Selecting .NET Objects and Methods
      • Choosing Between a DataSet and a DataReader
      • Using Parameter Markers as Arguments to Stored Procedures
      • Avoiding the CommandBuilder Object
    •  Designing .NET Applications
      • Using Connection Pooling
      • Opening and Closing Connections
      • Managing Commits in Transactions
      • Choosing the Right Transaction Model
      • Using Commands that Retrieve Little or No Data
      • Using Commands Multiple Times
      • Using Native Managed Providers
    •  Retrieving Data
      • Retrieving Long Data
      • Reducing the Size of Data Retrieved
      • Choosing the Right Data Type
    •  Updating Data
      • Synchronizing Changes Back to the Data Source
  • For More Information
•  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
  • Procedure Call Escape Sequences
•  Data Types Supported
  •  Supported Data Types
    • ODBC Client
    • ADO Client
    • JDBC Client
    • ADO.NET Client
•  JDBC Support
  • JDBC Compatibility
  •  Supported Functionality
    • Array Object
    • Blob Object
    • CallableStatement Object
    • Clob Object
    • Connection Object
    • ConnectionPoolDataSource Object
    • DatabaseMetaData Object
    • DataSource Object
    • Driver Object
    • ParameterMetaData Object
    • PooledConnection Object
    • PreparedStatement Object
    • Ref Object
    • Referenceable Object
    • ResultSet Object
    • ResultSetMetaData Object
    • RowSet Object
    • SavePoint Object
    • Serializable Object
    • Statement Object
    • StatementEventListener
    • Struct Object
•  JDBC Connection Pool Manager
  •  Creating a Data Source
    • Creating a DataDirect OpenAccess SDK Data Source Object
    • Creating a Data Source Using the DataDirect Connection Pool Manager
  • Connecting to a Data Source
  • Closing the Connection Pool
•  Troubleshooting Using DataDirect Spy
  •  Generating a DataDirect Spy Log
    • Turning On and Off DataDirect Spy Logging
    • ExtLogControl Class
    • DataDirect Spy Log Example
•  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