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 Oracle 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 Oracle Wire Protocol Driver
    • What's new in this release?
    • Driver requirements
    • Installing and setting up the driver (Windows)
    • Installing and setting up the driver (UNIX/Linux)
    • ODBC compliance
    • Version string information
      • getFileVersionString function
    • Data types
      • XMLType
        • Examples
      • Retrieving data type information
    • SQL support
    • Additional information
    • Contacting Technical Support
  • Tutorials
    • The Example application
    • Tableau (Windows only)
    • Microsoft Excel (Windows only)
    • Power BI (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
        • Data source configuration on UNIX/Linux
          • Configuring a data source in the system information 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
        • Performance tab
        • Failover tab
        • Pooling tab
        • Bulk tab
        • Client Monitoring tab
        • Advanced Security tab
        • Proxy tab
      • Using a connection string
      • Password Encryption Tool (UNIX/Linux only)
      • Using a logon dialog box
    • Performance considerations
    • Using LDAP
    • Connecting through a proxy server
      • Oracle Connection Manager
    • Support for Oracle RAC
    • XA interface support
    • MTS support
    • OS authentication
    • Isolation and lock levels supported
    • Unicode support
    • Using parameter arrays
    • Support of materialized views
    • Stored procedure results
    • Unexpected characters
    • 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
      • Configuring failover using the TNSNAMES.ORA file
    • Using client information
      • How databases store client information
      • Storing client information
    • Using security
      • Authentication
        • Kerberos requirements
        • Kerberos authentication
        • OS authentication
        • Oracle Internet Directory (OID)
        • Oracle Wallet SSL Authentication
        • Oracle Wallet Password Store
        • Entra ID access token authentication
      • Data encryption across the network
      • Data encryption and integrity
        • 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
        • Using Oracle Wallet as a keystore
        • Oracle Advanced Security
      • Summary of security-related options
    • 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 for Oracle
        • 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 bulk load for batch inserts
      • Determining the bulk load protocol
      • Limitations
      • Summary of related options for bulk load for batch inserts
    • Persisting a result set as an XML data file
      • Using the Windows XML persistence demo tool
      • Using the UNIX/Linux XML persistence demo tool
    • Packet logging
  • Connection option descriptions
    • Accounting Info
    • Action
    • Alternate Servers
    • Application Name
    • Application Using Threads
    • Array Size
    • Authentication Method
    • Batch Size
    • Batch Failure Returns Error
    • Bind Params As Unicode
    • Bulk Binary Threshold
    • Bulk Character Threshold
    • Bulk Options
    • Cached Cursor Limit
    • Cached Description Limit
    • Catalog Functions Include Synonyms
    • Catalog Options
    • Client Host Name
    • Client ID
    • Client User
    • Connection Pooling
    • Connection Reset
    • Connection Retry Count
    • Connection Retry Delay
    • Credentials Wallet Entry
    • Credentials Wallet Path
    • Crypto Protocol Version
    • CryptoLibName
    • Data Integrity Level
    • Data Integrity Types
    • Data Source Name
    • Default Buffer Size for Long/LOB Columns (in Kb)
    • Describe at Prepare
    • Description
    • Edition Name
    • Enable Bulk Load
    • Enable FIPS
    • Enable N-CHAR Support
    • Enable Scrollable Cursors
    • Enable Server Result Cache
    • Enable SQLDescribeParam
    • Enable Static Cursors for Long Data
    • Enable Timestamp with Timezone
    • Encryption Level
    • Encryption Method
    • Entra Access Token
    • Encryption Types
    • Failover Granularity
    • Failover Mode
    • Failover Preconnect
    • Fetch TSWTZ as Timestamp
    • Field Delimiter
    • GSS Client Library
    • Host
    • Host Name In Certificate
    • IANAAppCodePage
    • Impersonate User
    • Initialization String
    • Key Password
    • Key Store
    • Key Store Password
    • LDAP Crypto Protocol Version
    • LDAP Distinguished Name
    • LDAP Encryption Method
    • LDAP Key Store
    • LDAP Trust Store
    • LDAP Validate Server Certificate
    • Load Balancing
    • LoadBalance Timeout
    • LOB Prefetch Size
    • Local Timezone Offset
    • Lock Timeout
    • Login Timeout
    • Max Pool Size
    • Min Pool Size
    • Module
    • OpenSSLConfigFile
    • OpenSSLProviderPath
    • Password
    • Port Number
    • Proxy Host
    • Proxy Mode
    • Proxy Password
    • Proxy Port
    • Proxy User
    • PRNGSeedFile
    • PRNGSeedSource
    • Procedure Returns Results
    • Program ID
    • Query Timeout
    • Record Delimiter
    • Report Codepage Conversion Errors
    • Report Recycle Bin
    • SDU Size
    • Server Name
    • Server Process Type
    • Service Name
    • SID
    • SSLLibName
    • Support Binary XML
    • TCP Keep Alive
    • Timestamp Escape Mapping
    • TNSNames File
    • Trust Store
    • Trust Store Password
    • Use Current Schema for SQLProcedures
    • User Name
    • Validate Server Certificate
    • Wallet Password
    • Wire Protocol Mode
  • 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 23, 2020
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • Oracle Database Wire Protocol 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
  • Data source configuration on UNIX/Linux
  • The example application
  • 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