•  Welcome to the Progress DataDirect for ODBC for SQL Server Wire Protocol: Version 8.0.2
  • What's New in this Release?
  • Driver Requirements
  • ODBC Compliance
  •  Version String Information
    • getFileVersionString Function
  •  Support for Multiple Environments
    •  Support for Windows Environments
      • 32-Bit Driver Requirements
      • 64-Bit Driver Requirements
      • Setup of the Driver
      • Driver File Names for Windows
    •  Support for UNIX and Linux Environments
      • 32-Bit Driver Requirements for UNIX/Linux
      • 64-Bit Drivers Requirements for UNIX/Linux
      • AIX
      • HP-UX 11 aCC
      • Linux
      • Oracle Solaris
      • Setup of the Environment and the Drivers
      • Driver File Names for UNIX/Linux
  •  Data Types
    •  Unicode Support
      • Using the XML Data Type
    • Retrieving Data Type Information
  • Contacting Technical Support
•  Getting Started
  •  Configuring and Connecting on Windows
    • Configuring a Data Source
    • Testing the Connection
  •  Configuring and Connecting on UNIX and Linux
    • Environment Configuration
    • Test Loading the Driver
    • Configuring a Data Source in the System Information File
    • Testing the connection
  • Accessing Data With Third-Party Applications
•  Using the Driver
  •  Configuring and Connecting to Data Sources
    •  Configuring the Product on UNIX/Linux
      •  Environment Variables
        • Library Search Path
        • ODBCINI
        • ODBCINST
        • DD_INSTALLDIR
      • The Test Loading Tool
      •  Data Source Configuration on UNIX/Linux
        •  Configuration Through the System Information (odbc.ini) File
          • Sample Default odbc.ini File
      • The Example Application
      •  DSN-less Connections
        • Sample odbcinst.ini File
      • File Data Sources
      • UTF-16 Applications on UNIX and Linux
    •  Data Source Configuration through a GUI
      • Advanced Tab
      • Security Tab
      • Failover Tab
      • Pooling Tab
      • Bulk tab
    • Using a Connection String
    • Using a Logon Dialog Box
    • Performance Considerations
  •  Using Failover
    • Connection Failover
    • Extended Connection Failover
    • Select Connection Failover
    • Guidelines for Primary and Alternate Servers
    • Using Client Load Balancing
    • Using Connection Retry
    •  Configuring Failover-Related Options
      • A Connection String Example
      • An odbc.ini File Example
  •  Using Security
    •  Authentication
      • Kerberos Requirements
      • Kerberos Authentication
      • Configuring Azure Active Directory Authentication
      •  Summary of Authentication-Related Options
        • Connection String Examples for Configuring Authentication
        • odbc.ini File Examples for Configuring Authentication
    • Data Encryption Across the Network
    •  SSL Encryption
      • Certificates
      • SSL Server Authentication
      • SSL Client Authentication
      • Designating an OpenSSL Library
      •  Summary of Data Encryption Related Options
        • Connection String Examples for Configuring Data Encryption
        • odbc.ini File Examples for Configuring Data Encryption
    •  Always Encrypted
      • Enabling Always Encrypted
      • Using Keystore Providers
      • Caching Column Encryption Keys
      • Connection String Examples
  •  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 Options
  •  Using DataDirect Bulk Load
    • Bulk Export and Load Methods
    • Exporting Data from a Database
    • Bulk Loading to 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
    • Limitations
    • Summary of Related Options for DataDirect Bulk Load
  • Using IP Addresses
  • Binding Parameter Markers
  •  Isolation and Lock Levels Supported
    • Using The Snapshot Isolation Level
  • Number of Connections and Statements Supported
  • SQL Support
  • Using Arrays of Parameters
  • Support for Azure Synapse Analytics and Analytics Platform System
•  Troubleshooting
  •  Diagnostic Tools
    •  ODBC Trace
      • Creating a Trace Log
      •  Enabling Tracing
        • Windows ODBC Administrator
        • System Information (odbc.ini) File
    • The Test Loading Tool
    • ODBC Test
    • The Example Application
    • Other Tools
  • Error Messages
  •  Troubleshooting
    •  Setup/Connection Issues
      • Troubleshooting the Issue
    •  Interoperability Issues
      • Troubleshooting the Issue
    • Performance Issues
•  Connection Option Descriptions
  • AllowedOpenSSLVersions
  • Alternate Servers
  • Always Report Trigger Results
  • AnsiNPW
  • Application Intent
  • Application Name
  • Application Using Threads
  • Authentication Method
  • Batch Size
  • Bulk Binary Threshold
  • Bulk Character Threshold
  • Bulk Load Threshold
  • Bulk Options
  • Column Encryption
  • Connection Pooling
  • Connection Reset
  • Connection Retry Count
  • Connection Retry Delay
  • Crypto Protocol Version
  • CryptoLibName
  • Data Source Name
  • Database
  • Description
  • Domain
  • Enable Bulk Load
  • Enable Quoted Identifiers
  • Enable Server Side Cursors
  • Encryption Method
  • Failover Granularity
  • Failover Mode
  • Failover Preconnect
  • Fetch TSWTZ as Timestamp
  • Fetch TWFS as Time
  • Field Delimiter
  • GSS Client Library
  • Host Name
  • Host Name In Certificate
  • IANAAppCodePage
  • Initialization String
  • Key Cache Time To Live
  • Key Store Principal Id
  • Key Store Secret
  • Language
  • Load Balance Timeout
  • Load Balancing
  • Login Timeout
  • Max Pool Size
  • Min Pool Size
  • Multi-Subnet Failover
  • Packet Size
  • Password
  • Port Number
  • PRNGSeedFile
  • PRNGSeedSource
  • Proxy Host
  • Proxy Mode
  • Proxy Password
  • Proxy Port
  • Proxy User
  • Query Timeout
  • Record Delimiter
  • Report Codepage Conversion Errors
  • SSLLibName
  • TCP Keep Alive
  • Trust Store
  • Trust Store Password
  • Use Snapshot Transactions
  • User Name
  • Validate Server Certificate
  • Workstation ID
  • XML Describe Type
•  Reference
  •  What Is ODBC?
    • How Does It Work?
    • Why Do Application Developers Need ODBC?
  •  Code Page Values
    • IANAAppCodePage Values
  •  ODBC API and Scalar Functions
    • API Functions
    •  Scalar Functions
      • String Functions
      • Numeric Functions
      • Date and Time Functions
      • System Functions
  •  Internationalization, Localization, and Unicode
    •  Internationalization and Localization
      • Locale
      • Language
      • Country
      • Variant
    •  Unicode Character Encoding
      • Background
      • Unicode Support in Databases
      • Unicode Support in ODBC
    •  Unicode and Non-Unicode ODBC Drivers
      •  Function Calls
        • Unicode Application with a Non-Unicode Driver
        • Unicode Application with a Unicode Driver
      •  Data
        • Unicode Driver
        • ANSI Driver
      •  Default Unicode Mapping
        • Connection Attribute for Unicode
    •  Driver Manager and Unicode Encoding on UNIX/Linux
      • References
    • Character Encoding in the odbc.ini and odbcinst.ini Files
  •  Designing ODBC Applications for Performance Optimization
    •  Using Catalog Functions
      • Caching Information to Minimize the Use of Catalog Functions
      • Avoiding Search Patterns
      • Using a Dummy Query to Determine Table Characteristics
    •  Retrieving Data
      • Retrieving Long Data
      • Reducing the Size of Data Retrieved
      • 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 the Cursor Library
    •  Managing Connections and Updates
      • Managing Connections
      • Managing Commits in Transactions
      • Choosing the Right Transaction Model
      • Using Positioned Updates and Deletes
      • Using SQLSpecialColumns
  •  Using Indexes
    • Introduction
    • Improving Row Selection Performance
    • Indexing Multiple Fields
    • Deciding Which Indexes to Create
    • Improving Join Performance
  •  Locking and Isolation Levels
    • Locking
    • Isolation Levels
    • Locking Modes and Levels
  • SSL Encryption Cipher Suites
  •  DataDirect Bulk Load
    • DataDirect Bulk Load Functions
    •  Utility Functions
      • GetBulkDiagRec and GetBulkDiagRecW
    •  Export, Validate, and Load Functions
      • ExportTableToFile and ExportTableToFileW
      • ValidateTableFromFile and ValidateTableFromFileW
      • LoadTableFromFile and LoadTableFromFileW
    •  DataDirect Bulk Load Statement Attributes
      • SQL_BULK_EXPORT
      • SQL_BULK_EXPORT_PARAMS
  • WorkAround Options
  • Threading
•  Glossary
  • application
  • authentication
  • bulk load
  • client load balancing
  • conformance
  • connection pooling
  • connection retry
  • connection string
  • data source
  • driver
  • Driver Manager
  • DSN (Data Source Name)
  • DTC (Distributed Transaction Coordinator)
  • failover
  • index
  • isolation level
  • Kerberos
  • load balancing
  • locking level
  • MTS (Microsoft Transaction Server)
  • NTLM
  • ODBC Administrator
  • OS authentication
  • Performance Tuning Wizard
  • reauthentication
  • SQL Grammar
  • Secure Sockets Layer (SSL)
  • SSL client/server authentication
  • Unicode
  • user ID/password authentication
• Copyright