Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)Français (France)Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Progress DataDirect for ODBC for Microsoft SQL Server Wire Protocol Driver User's Guide Release 8.0.2

Copyright

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Welcome to the Progress DataDirect for ODBC for SQL Server Wire Protocol Driver
    • What's new in this release?
    • Driver requirements
    • Connection string examples
    • ODBC compliance
    • Version string information
      • getFileVersionString function
    • Data types
      • Unicode support
        • Using the XML data type
      • Retrieving data type information
    • Troubleshooting
    • Additional 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
  • Tutorials
    • The Example application
    • Accessing data in Microsoft Excel (Windows only)
    • Accessing data in Microsoft Excel from the Query Wizard (Windows only)
  • 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
        • 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
      • Password Encryption Tool (UNIX/Linux only)
      • 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 authentication
          • Connection string examples for configuring authentication
          • odbc.ini file examples for configuring authentication
        • Access token authentication
        • Microsoft Entra ID authentication
      • Data encryption across the network
      • TLS/SSL encryption
        • Certificates
        • TLS/SSL server authentication
          • Using SQL_COPT_INMEMORY_TRUSTSTORECERT
          • Importing root certificates into the Windows certificate store
            • Importing root certificates using Certificate Import Wizard
            • Importing root certificates using a PowerShell script
        • TLS/SSL client authentication
        • Generating TLS/SSL certificates using OpenSSL 3.5-compliant algorithms
        • Designating an OpenSSL Library
      • 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
    • XA interface support
    • 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
    • Support for Microsoft Fabric
    • Inserts on IDENTITY columns in data replication scenarios
    • Packet logging
  • Connection option descriptions
    • AE Keystore Location
    • AE Keystore Secret
    • 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 FIPS
    • Enable Quoted Identifiers
    • Enable Replication User
    • 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
    • Keep Connection Active
    • 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
    • OpenSSLConfigFile
    • OpenSSLProviderPath
    • 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
    • Socket Idle Time
    • SSLLibName
    • SuppressFabricWarnings
    • TCP Keep Alive
    • Trust Store
    • Trust Store Password
    • Use Snapshot Transactions
    • User Name
    • Validate Server Certificate
    • Workstation ID
    • XML Describe Type
  • Copyright
Table of Contents

Copyright

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: January 1, 2026
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • Microsoft SQL Server 8.0
    • Documentation

Visit the following page online to see Progress Software Corporation’s current Product Documentation Copyright Notice/Trademark Legend: https://www.progress.com/legal/documentation-copyright.

TitleResults for “How to create a CRG?”Also Available inAlert