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

Configuring the product on UNIX/Linux

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

Configuring the product on UNIX/Linux

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

This chapter contains specific information about using your driver in the UNIX and Linux environments.

See "Environment variables" for additional platform information.

Contents
  • Environment variables
  • The test loading tool
  • Data source configuration on UNIX/Linux
  • DSN-less connections
  • File data sources
  • UTF-16 applications on UNIX and Linux
Related Links
  • Environment variables
TitleResults for “How to create a CRG?”Also Available inAlert