Connect ODBC 7.1.6 UNIX
- Last Updated: May 8, 2026
- 39 minute read
- OpenAccess SDK
- Documentation
README
Progress(R) DataDirect(R)
DataDirect Connect(R) for ODBC
DataDirect Connect XE (Extended Edition) for ODBC
DataDirect Connect64(R) for ODBC
DataDirect Connect64 XE (Extended Edition) for ODBC
UNIX and Linux Platforms
Release 7.1.6
February 2026
***********************************************************************
Copyright (C) 2026 Progress Software Corporation and/or its
subsidiaries or affiliates. All Rights Reserved.
***********************************************************************
This README file provides information for Progress(R) DataDirect
Connect(R) Series for ODBC, which includes the following products:
* DataDirect Connect for ODBC
* DataDirect Connect64 for ODBC
* DataDirect Connect XE (Extended Edition) for ODBC
* DataDirect Connect64 XE for ODBC
This README file contains information not included in the DATADIRECT
CONNECT(R) SERIES FOR ODBC documentation.
CONTENTS
Post-GA Product Announcements
Installation Directory
Data Source and Platform Support
Changes Since Service Pack 6 GA
Changes for Service Pack 6 GA
Changes for Service Pack 5 GA
Changes for Service Pack 4 GA
Changes Since Service Pack 3 GA
Changes for Service Pack 3 GA
Changes Since Service Pack 2 GA
Changes for Service Pack 2 GA
Changes Since Service Pack 1 GA
Changes for Service Pack 1 GA
Release 7.1.0 Features
Available ODBC Drivers
Disk Space Requirements
Required Operating System Patches
Configuring Data Sources
Driver WorkAround Options
Notes, Known Problems, and Restrictions
Documentation
Installed Files for 32-bit Drivers
Installed Files for 64-bit Drivers
Post-GA Product Announcements
The readme files will no longer be updated with product announcements and new
features after the General Availability (GA) of the product. For the latest
updates and enhancements, please refer to the release notes
(https://www.progress.com/datadirect-connectors/whats-new).
Installation Directory
* The default installation directory for DataDirect Connect for ODBC
and DataDirect Connect XE for ODBC is:
/opt/Progress/DataDirect/Connect_for_ODBC_71
* The default installation directory for DataDirect Connect64 for ODBC
and DataDirect Connect64 XE for ODBC is:
/opt/Progress/DataDirect/Connect64_for_ODBC_71
Data Source and Platform Support
For the latest data source and platform support information, refer to the
Product Compatibility Guide:
https://docs.progress.com/bundle/datadirect-product-compatibility/resource/
datadirect-product-compatibility.pdf
Changes Since Service Pack 6 GA
Linux ODBC Administrator
------------------------
Support has ended for the DataDirect ODBC Data Source Administrator for Linux.
As a result, the Linux ODBC Administrator will no longer be installed with the
product. In addition, to avoid exposure to potential security vulnerabilities,
the installer program will remove Linux ODBC Administrator files from
existing installation directories during updates and new product installations.
SSL Enhancement (1.1.1t)
------------------------
The default version of the OpenSSL library has been upgraded to version
1.1.1t, which fixes the following security vulnerabilities:
* X.400 address type confusion in X.509 GeneralName (CVE-2023-0286)
* Use-after-free following BIO_new_NDEF (CVE-2023-0215)
* Double free after calling PEM_read_bio_ex (CVE-2022-4450)
* Timing Oracle in RSA Decryption (CVE-2022-4304)
This upgrade is available in build 07.16.0184 of the following OpenSSL
library files: libivtls27.so [.a] (32-bit) and libddtls27.so [.a] (64-bit).
Version 1.1.1t also addresses vulnerabilities resolved by earlier versions
of the library.
For more information on OpenSSL vulnerabilities resolved by this upgrade,
refer to the corresponding OpenSSL announcements at:
https://www.openssl.org/news/vulnerabilities-1.1.1.html
End of Support for OpenSSL 1.0.2
--------------------------------
The product no longer includes version 1.0.2 of the OpenSSL library.
The library has reached the end of its product life cycle and is not
receiving security updates anymore. Note that continuing to use the
library could potentially expose you to security vulnerabilities.
Note: As a result of this change, when installing a new version of the
driver, the installer program will automatically remove version 1.0.2
of the library from the install directory.
SSL Enhancement (1.1.1n)
------------------------
Note: OpenSSL library 1.1.1n has been replaced with version 1.1.1t. In
addition to fixing multiple new vulnerabilities, version 1.1.1t also
addresses the vulnerabilities resolved by version 1.1.1n.
The default version of the OpenSSL library has been upgraded to version
1.1.1n, which fixes the following security vulnerabilities:
* Infinite loop in BN_mod_sqrt() reachable when parsing certificates
(CVE-2022-0778)
* BN_mod_exp may produce incorrect results on MIPS (CVE-2021-4160)
This upgrade is available in build 07.16.0069 of the following OpenSSL library
files: libivtls27.so [.a] and libddtls27.so [.a] (64-bit).
SSL Enhancement (1.1.1l)
------------------------
Note: OpenSSL library 1.1.1l has been replaced with version 1.1.1n. In
addition to fixing multiple new vulnerabilities, version 1.1.1n also
addresses the vulnerabilities resolved by version 1.1.1l.
The default version of the OpenSSL library has been upgraded to version
1.1.1l, which fixes the following security vulnerabilities:
* SM2 Decryption Buffer Overflow (CVE-2021-3711)
* Read buffer overruns processing ASN.1 strings (CVE-2021-3712)
This upgrade is available in build 07.16.0061 of the following OpenSSL library
files: libivtls27.so [.a] and libddtls27.so [.a] (64-bit).
SSL Enhancement (1.1.1k)
------------------------
Note: OpenSSL library 1.1.1k has been replaced with version 1.1.1l. In
addition to fixing multiple new vulnerabilities, version 1.1.1l also
addresses the vulnerabilities resolved by version 1.1.1k.
The default version of the OpenSSL library has been upgraded to version
1.1.1k, which fixes the following security vulnerabilities:
* CA certificate check bypass with X509_V_FLAG_X509_STRICT (CVE-2021-3450)
* NULL pointer deref in signature_algorithms processing (CVE-2021-3449)
* Null pointer deref in X509_issuer_and_serial_hash() (CVE-2021-23841)
* Integer overflow in CipherUpdate (CVE-2021-23840)
This upgrade is available in build 07.16.0056 of the following OpenSSL library
file: libivtls27.so [.a] and libddtls27.so [.a] (64-bit).
Documentation
-------------
Any product package made available after February 9, 2021 will not include the
HTML help system or user's guide PDF. The Progress DataDirect Connect Series for
ODBC documentation set is available via product and data source tiles from the
Progress Information Hub:
https://docs.progress.com
While the product packages will not include these documentation items, the
installation Help directory will provide an HTML redirect for direct access
to the HTML help.
SSL Enhancement (1.1.1i)
------------------------
Note: OpenSSL library 1.1.1i has been replaced with version 1.1.1k. In
addition to fixing multiple new vulnerabilities, version 1.1.1k also
addresses the vulnerabilities resolved by version 1.1.1i.
The default version of the OpenSSL library has been upgraded to version 1.1.1i,
which fixes the following security vulnerabilities: Incorrect behavior of the
GENERAL_NAME_cmp function (CVE-2020-1971).
This upgrade is available in build 07.16.0045 of the following OpenSSL library
files: libivtls27.so [.a] and libddtls27.so [.a] (64-bit).
SSL Enhancement (1.1.1g)
------------------------
Note: OpenSSL library 1.1.1g has been replaced with version 1.1.1k. In
addition to fixing multiple new vulnerabilities, version 1.1.1k also
addresses the vulnerabilities resolved by version 1.1.1g.
The default version of the OpenSSL library has been upgraded to version 1.1.1g,
which fixes the following security vulnerabilities:
* Segmentation fault in SSL_check_chain (CVE-2020-1967)
* rsaz_512_sqr overflow bug on x86_64 (CVE-2019-1551)
Timestamp Logging in Packet Logs
--------------------------------
The drivers using base version B0548 and later have been enhanced to include
timestamp in the internal packet logs by default. If you want to disable the
timestamp logging in packet logs, set PacketLoggingOptions=1. The internal
packet logging is not enabled by default. To enable it, set
EnablePacketLogging=1.
Setting Unicode Encoding Type for Connections
---------------------------------------------
The Driver Manager for UNIX/Linux has been enhanced to support setting the
Unicode encoding type for applications on a per connection basis. By passing a
value for the SQL_ATTR_APP_UNICODE_TYPE attribute using SQLSetConnectAttr, your
application can specify the encoding at connection. This allows your
application to pass both UTF-8 and UTF-16 encoded strings with a single
environment handle.
The valid values for the SQL_ATTR_APP_UNICODE_TYPE attribute are SQL_DD_CP_UTF8
and SQL_DD_CP_UTF16. The default value is SQL_DD_CP_UTF8.
This enhancement is available in build 07.16.0398 of the driver manager.
SSL Enhancement (1.1.1d)
------------------------
Note: OpenSSL library 1.1.1d has been replaced with version 1.1.1g. In addition
to fixing multiple new vulnerabilities, version 1.1.1g also addresses the
vulnerabilities resolved by version 1.1.1d.
This upgrade is available in the 1.1.1 version of the OpenSSL library files,
libivtls27.so [.a] (32-bit) and libddtls27.so [.a] (64-bit).
(For SSL-enabled drivers) AllowedOpenSSLVersions
------------------------------------------------
Determines which version of the OpenSSL library file the driver uses for data
encryption when multiple versions are installed with the product. For example,
when specifying a value of 1.1.1 (AllowedOpenSSLVersions=1.1.1), the driver
uses the 1.1.1 version of the library stored in the /lib subdirectory. Refer to
the user's guide for more information.
DB2 Wire Protocol Driver
------------------------
* The driver has been enhanced to support Select queries with parameterized
arrays.
Greenplum Wire Protocol Driver
------------------------------
* The driver has been enhanced with the new BatchMechanism connection option,
which specifies the preferred mechanism for executing batch insert
operations. By setting Batch Mechanism to 2 (MultiRowInsert) or 3 (Copy), the
driver can achieve substantial performance gains when performing batch
inserts. The default setting is BatchMechanism=1 (SingleRowInsert).
* The driver has been enhanced to support the following data types: Citext,
Float, and Tinyint.
Impala Wire Protocol Driver
---------------------------
* The BatchMechanism connection option has been added to the driver. When
BatchMechanism is set to 2 (MultiRowInsert), the driver executes a single
insert for all the rows contained in a parameter array. MultiRowInsert is
the default setting and provides substantial performance gains when
performing batch inserts. Refer to the user's guide for details.
* The driver has been enhanced to support SSL encryption, which can be
configured using the following new connection options:
- CryptoLibName - CryptoProtocolVersion
- EncryptionMethod - HostNameinCertificate
- KeyPassword - KeyStore
- KeyStorePassword - SSLLibName
- TrustStore - TrustStorePassword
- ValidateServerCertificate
SSL support was formally certified against driver version 07.16.0317
(B0386, U0249). Refer to the user's guide for additional information.
Oracle Wire Protocol Driver
---------------------------
* The maximum supported length of identifiers has been increased to 128 bytes
when connecting to Oracle 12c R2 (12.2) databases. This change has been
implemented to reflect the new maximum length supported by the server.
PostgreSQL Wire Protocol Driver
-------------------------------
* The driver has been enhanced to support the scram-sha-256-plus authentication
method, which uses channel binding for establishing a secure connection with
PostgreSQL (v11.0 and higher).
* The driver has been enhanced with the new Batch Mechanism (BatchMechanism)
connection option, which specifies the preferred mechanism for executing
batch insert operations. By setting Batch Mechanism to 2 (MultiRowInsert) or
3 (Copy), the driver can achieve substantial performance gains when
performing batch inserts. The default setting is BatchMechanism=1
(SingleRowInsert).
* The driver has been enhanced to support the following data types: Citext,
Float, and Tinyint.
* For PostgreSQL 9.0 and later, the driver behavior has been updated to support
executing multiple prepared statements in a single query that contain inserts
for BYTEA values. However, for versions earlier than PostgreSQL 9.0, this
functionality is not supported and the driver returns an error.
* The driver has been enhanced to support Select queries with parameterized
arrays.
* The driver has been enhanced to support md5 and scram-sha-256 authentication
methods.
* The driver has been enhanced to support materialized views and
foreign tables.
Progress OpenEdge Wire Protocol Driver
--------------------------------------
* The driver has been enhanced to support the SQLCancel function for SELECT
statements with OpenEdge V12.4 and higher. If a SELECT statement is cancelled
during the first or a subsequent fetch operation, the driver returns a
"query aborted" exception. This method can be used by a thread to cancel a
statement that is being executed by another thread. One or more statements may
be cancelled if the method is called on a statement object that is executing
multiple statements simultaneously and the driver may not return expected
results. The driver supports this function for ODBC 3.x applications only.
SQL Server Wire Protocol
------------------------
* The 7.1 version of the driver no longer supports the curl library.
As a result, the following functionality will no longer be supported:
Azure Active Directory Authentication.
* The driver is enhanced to support Azure Active Directory authentication
(Azure AD). Azure AD authentication is an alternative to SQL Server
Authentication for Azure SQL Database that allows you to centrally manage
identities of database users. To enable Azure AD authentication, specify the
new 13 (Active Directory Password) value for the Authentication Method
connection option (AuthenticationMethod=13). In addition, specify the
respective values in the connection string or data source definition for the
HostNameInCertificate, Truststore, ValidateServerCertificate, LogonID and
Password connection options. Refer to "Configuring Azure Active Directory
Authentication" in the user's guide for more information.
* The driver has been enhanced to support Always On Availability Groups.
Introduced in SQL Server 2012, Always On Availability Groups is a
replica-database environment that provides a high-level of data availability,
protection, and recovery. To support this enhancement, the following updates
have been made to the driver:
- The HostName option has been updated to support the virtual network
name (VNN) of the availability group listener as a valid value. To connect
to an Always On Availability group, you must specify the VNN using this
option.
- The new ApplicationIntent option allows you to control whether the driver
requests read-only routing, thereby improving efficiency by reducing the
workload on read-write nodes.
- The new MultiSubnetFailover option allows the driver to attempt parallel
connections to all the IP addresses associated with an availability group
when the primary listener is unavailable. This offers improved response
time over traditional failover, which attempts connections to alternate
servers one at a time.
Refer to the user's guide for details.
Sybase Wire Protocol Driver
---------------------------
* The driver has been enhanced to support Sybase Extended Password Encryption
and Sybase Extended Plus Encrypted Password, which use an asymmetrical key
type. This provides stronger password encryption for the secure transmission
of public key passwords over networks.
* The driver has been enhanced to support binary and varbinary data types when
using the bulk load protocol.
Driver for Teradata
-------------------
* The driver has been enhanced to support the Number data type. Refer to
the user's guide for additional information.
Text Driver
-----------
* A Connect64 (64-bit) version of the Text driver is now generally available.
This new driver provides 64-bit support for the features and functionality
offered by the earlier DataDirect Connect (32-bit) version of the driver.
Notes:
- The Connect64 Text driver uses a driver-specific installer, instead of
the Connect Series installer that is used for the Connect (32-bit) Text
driver. Both the installer for the Connect64 Text driver and the Connect
Series installer are available on the Progress website.
- The control numbers available in the new control number format
(8.0 control numbers) must be used for installing the Connect64 Text driver,
instead of those available in the old format (7.1 control numbers).
- On Linux platforms: The installer for the Connect64 Text driver deploys an
OpenJDK 11 Java Runtime Environment(JRE) that it uses to install the
product.
- On non-Linux platforms: The installer for the Connect64 Text driver
requires a Java Runtime Environment (JRE) that is Java SE 8 or higher.
Refer to the fixes.txt file in the product installation directory for a list of
changes by build number.
Changes for Service Pack 6 GA
Driver for Apache Hive
----------------------
* The driver has been enhanced to support row-level inserts when connected
to Hive 0.14 or higher.
* The BatchMechanism connection option has been added to the driver. By
setting BatchMechanism to 2 (MultiRowInsert), you enable the driver to use a
parameterized multi-row insert statement to execute batch inserts.
MultiRowInsert is the default setting and provides substantial performance
gains when performing batch inserts.
* The AuthenticationMethod connection option has been refreshed with a new
valid value for enabling Kerberos Authentication. To use Kerberos
authentication with the driver, set AuthenticationMethod=4.
* The new CryptoLibName and SSLLibName connection options allow you to
designate the OpenSSL libraries used when SSL is enabled.
* The driver has been enhanced to support SSL encryption, which can be
configured using the following new connection options:
- CryptoProtocolVersion - KeyStorePassword
- EncryptionMethod - TrustStore
- HostNameinCertificate - TrustStorePassword
- KeyPassword - ValidateServerCertificate
- KeyStore
* The ArraySize connection option has been refreshed to allow specifying
the number of cells retrieved instead of rows. By determining the fetch size
based on the number of cells, the driver can avoid out of memory errors when
fetching from tables containing a large number of columns.
DB2 Wire Protocol Driver
------------------------
* The new CryptoLibName and SSLLibName connection options allow you to
designate the OpenSSL libraries used when SSL is enabled.
* The new Min Long Varchar Size connection option allows you to fetch
SQL_LONGVARCHAR columns whose size is smaller than the minimum
imposed by some third-party applications. For more information, refer to the
DATADIRECT CONNECT FOR ODBC SERIES USER'S GUIDE.
* The new Varchar Threshold connection option allows you to fetch columns
that would otherwise exceed the upper limit of the SQL_VARCHAR type for some
third-party applications.
Greenplum Wire Protocol
-----------------------
* The new CryptoLibName and SSLLibName connection options allow you to
designate the OpenSSL libraries used when SSL is enabled.
* Support for Kerberos Authentication, which can be configured using the
following new connection options:
-AuthenticationMethod
-GSSClient
-LoginID
-ServicePrincipalName
Impala Wire Protocol
--------------------
* The AuthenticationMethod connection option has been refreshed with a new
valid value for enabling Kerberos Authentication. To use Kerberos
authentication with the driver, set AuthenticationMethod=4.
* Support for Kerberos Authentication, which can be configured using the
following new connection options:
-AuthenticationMethod
-GSSClient
-ProxyUser
-ServicePrincipalName
Kerberos support is available starting with the 7.15.0255 (BO242, U0169)
build of the driver.
* Certified with Apache Sentry for Impala 1.1 and higher. Sentry enables
administrators to control access to data and metadata stored on an Hadoop
cluster by defining user roles and permissions.
* The driver has been enhanced to support the Char, Decimal, and Varchar data
types when connected to Impala 2.0 and higher.
* The ArraySize connection option has been refreshed to allow specifying
the number of cells retrieved instead of rows. By determining the fetch size
based on the number of cells, the driver can avoid out of memory errors when
fetching from tables containing a large number of columns.
MySQL Wire Protocol Driver
--------------------------
* The new CryptoLibName and SSLLibName connection options allow you to
designate the OpenSSL libraries used when SSL is enabled.
Oracle Wire Protocol Driver
---------------------------
* The new CryptoLibName and SSLLibName connection options allow you to
designate the OpenSSL libraries used when SSL is enabled.
PostgreSQL Wire Protocol
------------------------
* The new CryptoLibName and SSLLibName connection options allow you to
designate the OpenSSL libraries used when SSL is enabled.
* Support for Kerberos Authentication, which can be configured using the
following new connection options:
-AuthenticationMethod
-GSSClient
-ProxyUser
-ServicePrincipalName
Progress OpenEdge Wire Protocol Driver
--------------------------------------
* The new CryptoLibName and SSLLibName connection options allow you to
designate the OpenSSL libraries used when SSL is enabled.
SQL Server Wire Protocol
------------------------
* The new CryptoLibName and SSLLibName connection options allow you to
designate the OpenSSL libraries used when SSL is enabled.
Sybase Wire Protocol
--------------------
* The new CryptoLibName and SSLLibName connection options allow you to
designate the OpenSSL libraries used when SSL is enabled.
For more information about these features, refer to the DATADIRECT CONNECT
FOR ODBC SERIES USER'S GUIDE.
Changes for Service Pack 5 GA
Driver for Apache Hive
----------------------
* Certified with Apache Hive Sentry, which enables HiveServer2 administrators
to enforce role-based authorization for Apache Hadoop clusters. Refer to the
DATADIRECT CONNECT FOR ODBC SERIES USER'S GUIDE for additional Information.
* The driver has been enhanced to support the Char data type
when connected to Hive 0.13 and higher.
* The driver has been enhanced to support the Decimal data type
when connected to Hive 0.11 and higher.
* The driver has been enhanced to support the Date and Varchar data types
in Hive 0.12 and higher.
DB2 Wire Protocol Driver
------------------------
* The new Crypto Protocol Version connection option allows you to specify
the cryptographic protocols used when SSL is enabled. This option can be
used to avoid vulnerabilities associated with SSLv3 and SSLv2, including
the POODLE vulnerability.
Greenplum Wire Protocol Driver
------------------------------
* The new Crypto Protocol Version connection option allows you to specify
the cryptographic protocols used when SSL is enabled. This option can be
used to avoid vulnerabilities associated with SSLv3 and SSLv2, including
the POODLE vulnerability.
* The new Unbounded Numeric Precision connection option allows you to
define the precision for unbounded NUMERIC columns when described
within the column, parameter, result set, or table metadata.
* The new Unbounded Numeric Scale connection option allows you to
define the scale for unbounded NUMERIC columns described within
the column, parameter, result set, or table metadata.
MySQL Wire Protocol Driver
--------------------------
* The new Crypto Protocol Version connection option allows you to specify
the cryptographic protocols used when SSL is enabled. This option can be
used to avoid vulnerabilities associated with SSLv3 and SSLv2, including
the POODLE vulnerability.
Oracle Wire Protocol Driver
---------------------------
* The new PRNGSeedSource connection option allows you to specifies whether the
driver uses a file or the RAND_poll function as the seed source for
SSL key generation.
* The new PRNGSeedFile connection option allows you to specify the
entropy-source file or device used as a seed for SSL key generation.
* The new Crypto Protocol Version connection option allows you to specify
the cryptographic protocols used when SSL is enabled. This option can be
used to avoid vulnerabilities associated with SSLv3 and SSLv2, including
the POODLE vulnerability.
PostgreSQL Wire Protocol Driver
-------------------------------
* The new Crypto Protocol Version connection option allows you to specify
the cryptographic protocols used when SSL is enabled. This option can be
used to avoid vulnerabilities associated with SSLv3 and SSLv2, including
the POODLE vulnerability.
* The new Unbounded Numeric Precision connection option allows you to
define the precision for unbounded NUMERIC columns described
within the column, parameter, result set, or table metadata.
* The new Unbounded Numeric Scale connection option allows you to
define the scale for unbounded NUMERIC columns described within
the column, parameter, result set, or table metadata.
Progress OpenEdge Wire Protocol Driver
--------------------------------------
* The new Crypto Protocol Version connection option allows you to specify
the cryptographic protocols used when SSL is enabled. This option can be
used to avoid vulnerabilities associated with SSLv3 and SSLv2, including
the POODLE vulnerability.
SQL Server Wire Protocol Driver
-------------------------------
* The driver has been enhanced to support NTLMv2 authentication, which can be
enabled using the AuthenticationMethod connection option.
* The new PRNGSeedSource connection option allows you to specifies whether the
driver uses a file or the RAND_poll function as the seed source for
SSL key generation.
* The new PRNGSeedFile connection option allows you to specify the
entropy-source file or device used as a seed for SSL key generation.
* The new Crypto Protocol Version connection option allows you to specify
the cryptographic protocols used when SSL is enabled. This option can be
used to avoid vulnerabilities associated with SSLv3 and SSLv2, including
the POODLE vulnerability.
Sybase Wire Protocol Driver
---------------------------
* The new PRNGSeedSource connection option allows you to specifies whether the
driver uses a file or the RAND_poll function as the seed source for
SSL key generation.
* The new PRNGSeedFile connection option allows you to specify the
entropy-source file or device used as a seed for SSL key generation.
* The new Crypto Protocol Version connection option allows you to specify
the cryptographic protocols used when SSL is enabled. This option can be
used to avoid vulnerabilities associated with SSLv3 and SSLv2, including
the POODLE vulnerability.
For more information about these features, refer to the DATADIRECT CONNECT FOR
ODBC SERIES USER'S GUIDE.
Changes for Service Pack 4 GA
No features introduced
Changes Since Service Pack 3 GA
Driver for Apache Hive
----------------------
* The new TCP Keep Alive connection option allows you to
use TCP Keep Alive to maintain idle TCP connections.
DB2 Driver
----------
* The new TCP Keep Alive connection option allows you to
use TCP Keep Alive to maintain idle TCP connections.
Greenplum Wire Protocol Driver
------------------------------
* The new TCP Keep Alive connection option allows you to
use TCP Keep Alive to maintain idle TCP connections.
MySQL Wire Protocol
-------------------
* The new TCP Keep Alive connection option allows you to
use TCP Keep Alive to maintain idle TCP connections.
Oracle Wire Protocol Driver
---------------------------
* The new TCP Keep Alive connection option allows you to
use TCP Keep Alive to maintain idle TCP connections.
PostgreSQL Wire Protocol Driver
-------------------------------
* The new TCP Keep Alive connection option allows you to
use TCP Keep Alive to maintain idle TCP connections.
Progress OpenEdge Wire Protocol Driver
--------------------------------------
* The new TCP Keep Alive connection option allows you to
use TCP Keep Alive to maintain idle TCP connections.
SQL Server Wire Protocol
------------------------
* The new TCP Keep Alive connection option allows you to
use TCP Keep Alive to maintain idle TCP connections.
Sybase Wire Protocol Driver
---------------------------
* The new TCP Keep Alive connection option allows you to
use TCP Keep Alive to maintain idle TCP connections.
For more information about these features, refer to the
DATADIRECT CONNECT FOR ODBC SERIES USER'S GUIDE.
Changes for Service Pack 3 GA
Driver for Apache Hive
----------------------
* The Use Native Catalog Functions connection option allows you to use native
catalog functions to retrieve information returned by SQLTables, SQLColumns,
and SQLStatistics catalog functions.
* Support for Kerberos Authentication, which can be configured using the
following connection options:
-Authentication Method specifies the method the driver uses to authenticate
the user to the server when a connection is established.
-GSS Client Library specifies the GSS client library that the driver uses to
communicate with the Key Distribution Center (KDC).
-Proxy User Specifies the UserID used for HiveServer2 impersonation and
HiveServer2 Trusted Impersonation.
-Service Principal Name specifies the service principal name to be used by
driver for Kerberos authentication.
For more information about these features, refer to the
DATADIRECT CONNECT FOR ODBC SERIES USER'S GUIDE.
Changes Since Service Pack 2 GA
Greenplum Driver
----------------
* SSL support for Greenplum 4.2, incorporating nine additional connection
options.
Oracle Wire Protocol Driver
---------------------------
* Modified to support all Oracle 11gR2 Kerberos encryption algorithms.
PostgreSQL Driver
-----------------
* The Encryption Method connection option now supports Request SSL
functionality. When Request SSL is enabled, login requests and data are
encrypted if the server is configured for SSL. If the server is not
configured for SSL, an unencrypted connection is established.
For more information about these features, refer to the
DATADIRECT CONNECT FOR ODBC SERIES USER'S GUIDE.
Changes for Service Pack 2 GA
New Driver
----------
* DataDirect Connect XE for ODBC Impala Wire Protocol driver
- Certified with Cloudera Impala database server and formally
certified with the following file formats and storage handlers:
- File Formats:
- Parquet
- Text File
- Storage Handlers:
- HBase
- Returns result set metadata for parameterized statements
that have been prepared but not yet executed.
- Supports parameter arrays, processing the arrays as a series of
executions, one execution for each row in the array.
- Provides a connection option that allows you to configure
the driver to report that it supports transactions, although
Hive does not support transactions. This provides a workaround
for applications that do not operate with a driver that reports
transactions are not supported.
- Provides a connection option that allows you to set a default limit for
the number of rows returned when an ORDER BY clause is submitted. This
provides a workaround for applications that are not compatible with
Impala's requirement that ORDER BY clauses limit the number of rows returned.
- The driver provides support for the following standard SQL
functionality:
- Create Index and Create Table
- Insert, Update, and Delete
- Drop Index and Drop Table
For more information about these features, refer to the
DATADIRECT CONNECT FOR ODBC SERIES USER'S GUIDE.
Changes Since Service Pack 1 GA
Driver for Apache Hive(TM)
--------------------------
The Driver for Apache Hive Version 7.1.1 has been refreshed and
contains the following changes since the GA release:
* The String Describe Type connection option now allows you to describe
string columns as SQL_WLONGVARCHAR or SQL_WVARCHAR.
Changes for Service Pack 1 GA
Driver for Apache Hive(TM)
--------------------------
The Driver for Apache Hive Version 7.1.0 has been refreshed and
contains the following changes since the GA release:
* Added support for HiveServer2.
* The Password connection attribute is now required for a connection
to HiveServer2.
* The UserName connection attribute is now required for a connection
to HiveServer2.
* When connected to HiveServer2, simultaneous connections per port
are supported.
* The new WireProtocolVersion connection attribute specifies the
version of the Hive Server to which the driver will connect.
NOTE: If the value set for WireProtocolVersion does not match the
version of the Hive server to which you are connecting, the connection
fails with a login timeout error, if LoginTimeout is enabled.
For example, a login timeout error is returned if the driver attempts
to connect to a HiveServer1 data source when WireProtocolVersion=2.
For more information about these features, refer to the
DATADIRECT CONNECT FOR ODBC SERIES USER'S GUIDE.
Release 7.1.0 Features
New Database Version Support
----------------------------
* DB2 V10.1 for Linux, UNIX, Windows (LUW)
* DB2 V9.8 for Linux, UNIX, Windows (LUW)
* Greenplum 4.2
* Microsoft SQL Server 2012
* Microsoft Windows Azure for SQL Database
* Teradata 14.0
New Driver
----------
* DataDirect Connect XE for ODBC for Apache Hive(TM) Wire Protocol driver
- Supported with the following Apache Hive versions:
- Amazon Elastic MapReduce (Amazon EMR)
- Apache Hadoop Hive
- Cloudera's Distribution Including Apache Hadoop (CDH)
- MapR Distribution for Apache Hadoop
- Returns result set metadata for parameterized statements
that have been prepared but not yet executed.
- Supports parameter arrays, processing the arrays as a series of
executions, one execution for each row in the array.
- Provides a connection option that allows you to configure
the driver to report that it supports transactions, although
Hive does not support transactions. This provides a workaround
for applications that do not operate with a driver that reports
transactions are not supported.
- The driver provides support for the following standard SQL
functionality:
- Create Index, Create Table, and Create View
- Insert
- Drop Index, Drop Table, and Drop View
Oracle Wire Protocol Driver Enhancements
----------------------------------------
* Support for Oracle Advanced Security (OAS), which can be configured
using the following connection options:
- DataIntegrityLevel sets the level of OAS data integrity
used for data sent between the driver and database server.
- DataIntegrityTypes specifies one or multiple algorithms to protect against
attacks that intercept and modify data being transmitted between the client
and server when OAS data integrity is enabled using the DataIntegrityLevel
property.
- EncryptionLevel determines whether data is encrypted and decrypted when
transmitted over the network between the driver and database server using
OAS encryption.
- EncryptionTypes specifies one or multiple algorithms to use if OAS encryption
is enabled using the EncryptionLevel property.
Salesforce Driver
-----------------
* The RefreshSchema option determines whether the driver automatically
refreshes the remote object mapping and other information contained
in a remote schema the first time a user connects to the specified
embedded database.
* The KeywordConflictSuffix keyword=value pair specifies a string of up to
five alphanumeric characters that the driver appends to any object or
field name that conflicts with a SQL engine keyword. For example,
if you specify KeywordConflictSuffix=TAB, then the driver maps the
Case object in Salesforce to CASETAB.
For more information about these features, refer to the
DATADIRECT CONNECT FOR ODBC SERIES USER'S GUIDE.
Available ODBC Drivers
Database drivers are continually being added to each operating
environment. For the latest information about the specific drivers
available for your platform, refer to the Progress DataDirect database
support matrix Web page.
Disk Space Requirements
The following available disk space requirements assume a full
installation of all 32-bit drivers and options.
AIX 158 MB
Linux x86 127 MB
Solaris SPARC 185 MB
Solaris x86 137 MB
The following available disk space requirements assume a full
installation of all 64-bit drivers and options.
AIX 150 MB
Linux Itanium 111 MB
Linux x64 132 MB
Solaris SPARC 187 MB
Solaris x64 160 MB
Required Operating System Patches
For Oracle Users Only
---------------------
If you are using Oracle 8.1.7, you must have the 8.1.7.1 server
patch installed. Otherwise, you may receive the Oracle error:
"ORA-03120: two-task conversion routine: integer overflow"
when fetching LOB data.
Configuring Data Sources
Data sources are stored in the system information file (typically,
odbc.ini). For details on configuring this file, see the DATADIRECT
CONNECT SERIES FOR ODBC USER'S GUIDE.
Driver WorkAround Options
Progress DataDirect has included non-standard connection options (workarounds)
for the driver that enable you to take full advantage of packaged ODBC-enabled
applications requiring non-standard or extended behavior. Refer to the chapter
"WorkAround options" in THE PROGRESS DATADIRECT FOR ODBC DRIVERS REFERENCE for a
description of these options.
Notes, Known Problems, and Restrictions
The following are notes, known problems, or restrictions with Release
7.1.6 of the DataDirect Connect Series for ODBC drivers.
NOTE: For maximum compatibility, the version of the DataDirect Connect
Series for ODBC drivers and the version of the DataDirect Connect Series
for ODBC Driver Manager must match.
PostgreSQL: Batch Mechanism Option
----------------------------------
GUI Name:
Batch Mechanism
Attribute:
BatchMechanism (BM)
Purpose:
Determines the mechanism that is used to execute batch operations.
Valid Values:
1 | 2 | 3
Behavior:
If set to 1 (SingleRowInsert), the driver executes an insert statement for each
row contained in a parameter array. Specify this value if you are experiencing
out-of-memory errors when performing batch inserts.
If set to 2 (MultiRowInsert), the driver attempts to execute a single insert
statement for all the rows contained in a parameter array. If the size of the
insert statement exceeds the available buffer memory of the driver, the driver
executes multiple statements. Specify this value for substantial performance
gains over 1 (SingleRowInsert) when performing batch inserts.
If set to 3 (Copy), the driver uses the PostgreSQL COPY command to insert rows
into the target table. Specify this value for substantial performance gains
over 1 (SingleRowInsert) when performing batch inserts.
Notes:
* Batch Mechanism determines the mechanism used to perform batch inserts only.
For update and delete batch operations, the driver uses the native batch
mechanism to handle the request.
* When BatchMechanism=3, substantial performance gains can be made. However,
the following limitations apply:
- Individual update counts are not returned. However, the total number of
inserted rows are returned the execution of a batch operation.
- The entire batch insert is ATOMIC. If any issues are encountered, the
entire operation fails and no rows are inserted.
Default:
2 (MultiRowInsert)
GUI Tab:
Advanced
Driver for IBM DB2 - Default Value of XMLDescribeType Attribute
---------------------------------------------------------------
The difference in default value of XMLDescribeType attribute between
Unix/Linux and Windows platforms is a known issue. It will be resolved
in the 8.0 version of the driver.
Workaround: In the odbc.ini file, set the XMLDescribeType attribute to
the required value in the data source definition.
DashDB Constraints for Tables
-----------------------------
By default, dashDB does not enforce constraints for tables. As a result, dashDB
will not enforce uniqueness on the new tables, and therefore, incorrect or
unexpected results can occur if table data violates the not-enforced
constraint. If you want to enforce uniqueness, specify the ENFORCED parameter
when creating or altering unique or referential constraints, such as primary
keys and foreign keys.
Disabling Diffie-Hellman Cipher Suites
--------------------------------------
If your database has not been fixed to address the Logjam vulnerability, you
can still use the most recent version of the OpenSSL Library by disabling the
Diffie-Hellman cipher suites. To disable the Diffie-Hellman cipher suites,
specify the following value for the undocumented CipherList connection option:
CipherList=DEFAULT:-DH
If you have already specified a value for CipherList, add the following to the
existing value:
:-DH
The option-value pair for undocumented options can be specified in the
odbc.ini, connection string, or the Extended Options field of the GUI. For
details, refer to "Configuring and Connecting to Data Sources" in the
individual driver chapters of the DATADIRECT CONNECT SERIES FOR ODBC
USER'S GUIDE.
Precision and Scale for Apache Hive 0.13 Decimal Data Type
----------------------------------------------------------
When calling SQLGetInfo or SQLDescribeColumn against Hive 0.13
servers, the driver incorrectly returns a precision of 38 digits and
scale of 32 digits for the DECIMAL data type. Using the default
settings, the correct precision is 10 digits and the correct scale is
0 digits.
Oracle 12c Kerberos Authentication
----------------------------------
The driver has not been certified against Kerberos authentication on
Oracle 12c databases.
For Pivotal HAWQ Users
----------------------
The following are known limitations for using Pivotal
HAWQ with the Greenplum Wire Protocol driver:
*No support for updates.
*No support for deletes.
*No support for stored procedures.
Oracle XMLType Data Type
------------------------
The Oracle and Oracle Wire Protocol driver provide support for
XMLType columns, except those with binary or object relational
storage. Starting with Oracle 11.2.0.2, the default XML storage
type was changed from CLOB to BINARY. Consequently, columns created
simply as "XMLType" against Oracle 11.2.0.2 and later versions are not
supported by the drivers. An attempt to obtain the value of such a column
through the driver results in the exception "This column type is not
currently supported by this driver." To avoid this exception when
running the driver against Oracle 11.2.0.2 and later versions, change
the XML storage type to CHARACTER (CLOB) or use the TO_CLOB Oracle
function to cast the column.
For SSL Users
-------------
When trying to connect to a database using SSL encryption, you may
receive an error message similar to: "PRNG not seeded". This is because
certain versions of some operating systems do not generate truly random
numbers necessary for encryption. For more information about this error
and available patches, please refer to the Web site:
http://www.openssl.org/support/faq.html#USER1
On SUSE Linux Enterprise Server 10.0, attempts by the drivers to
connect using SSL Encryption will not succeed due to a problem loading
the SSL libraries.
SSL and the Linux ODBC Administrator
-----------------------------------
The Linux ODBC Administrator does not correctly save the encrypted
truststore password, keystore password, and key password in the
odbc.ini file when specifying them on the Security tab of the driver
Setup dialog boxes. To set these connection options, you must edit the
odbc.ini file directly and use the appropriate connection string
attributes to store these passwords in the file. You cannot use the
driver Setup dialog boxes. See the DATADIRECT CONNECT SERIES FOR ODBC
USER'S GUIDE for details about the Security tabs and the odbc.ini file.
ODBC Development on UNIX and Linux Platforms
--------------------------------------------
All of the Release 7.1 Core Components (header files, etc.) needed for
development of ODBC applications on UNIX and Linux are installed into
the /include directory created by the product installer.
Please read the notices.txt file in the installation directory for
licensing information regarding the ODBC Core Components. Contact your
Progress DataDirect representative if you have any questions.
Developers using programming languages other than C++:
The DataDirect ODBC Driver Manager is a C++ shared library. The ODBC
Driver Manager can be used with any language that supports loading a
C++ shared library; however, if you are using a programming language
other than C++, you must take additional steps to ensure that the C++
libraries are initialized properly when loaded. If you are not using
C++, consult your compiler documentation for instructions on using C++
shared libraries with your application.
LANG Environment Setting on UNIX and Linux Platforms
----------------------------------------------------
A default installation of the product on UNIX and Linux assumes that
the value of the LANG environment setting is en_US. If your locale is
not set to en_US, the drivers may not return error messages properly.
In this case, you must create a symbolic link in the
<Install_Dir>/locale directory that has the same value as the LANG
environment setting. This link must point to the
<Install_Dir>/locale/en_US directory.
SQLColAttribute(s)
------------------
The column attributes 1001 and 1002, which were assigned as DataDirect-
specific attributes, were inadvertently used as system attributes by
the Microsoft 3.0 ODBC implementation. Applications using those
attributes must now use 1901 and 1902, respectively.
SQL_C_NUMERIC
-------------
Because of inconsistencies in the ODBC specification, users attempting
to use SQL_C_NUMERIC parameters must set the precision and scale values
of the corresponding structure and the descriptor fields in the
Application Parameter Descriptor.
For Informix Users
------------------
Restriction: Some Informix error messages may contain more than one
error. All errors displayed may not be valid.
For Microsoft SQL Server Users
------------------------------
Attempting to execute DDL statements that contain errors causes
an implicit rollback of the current transaction if executing in
manual commit mode. No warning occurs when this happens. This is a
Microsoft SQL Server limitation, and no driver workaround is available.
NOTE: Because the SQL Server Wire Protocol drivers do not have a way to
prepare statements, the driver does not send those statements to the
server until SQLExecute is called. PREPARE does not return any of the
normal errors that most of the drivers return. If, however, the user
requests information about result columns, the driver executes a Select
statement and returns warnings or errors when using SQLNumResultCols,
SQLDescribeCol, or SQLColAttributes.
If you have problems with the catalog functions returning incorrect
data, you may need to upgrade your catalog stored procedures. Make
sure that you have installed the latest version of the stored
procedures, which are available from your database vendor. Refer to
your Microsoft SQL Server documentation for more information.
The SQL Server Wire Protocol drivers return stored procedure names with
the version number appended to them. For example, a procedure defined
as "proc1" will be returned as "proc1;1".
The SQL Server Legacy Wire Protocol driver does not support multiple
active statements on a single connection by default. See the Microsoft
document for information about how to enable multiple active statements
on a single connection using server-side cursors:
http://support.microsoft.com/kb/q140896/
When using the SQLDescribeParam method, the SQL Server Legacy Wire
Protocol driver describes parameters that map to the Microsoft SQL
Server 2008 date, time, datetime2, and datetimeoffset data types as
SQL_WVARCHAR.
For Sybase Users
----------------
* For values of the real data type, to comply with the Sybase
server, the driver ensures the accuracy of the values
loaded through bulk load only up to 6 digits.
* For values of the money data type, to comply with the Sybase
server, if an application provides a scale (number of digits to
the right of the decimal) greater than 4, the driver truncates
it to 4.
* The driver does not support inserting data containing LOB columns
using the bulk load protocol. In such cases, the driver throws a
warning and falls back to the native protocol to continue executing
the inserts.
* When using Bulk load to execute an insert statement, the operation
will fail with an error message if non-identity columns are omitted
from the statement.
* You may experience a problem using catalog stored procedures when
running the Sybase Wire Protocol driver with Sybase Adaptive Server
11.5. Contact Sybase and ask for the latest version of their catalog
stored procedures.
The Sybase Wire Protocol driver supports the QUERY_TIMEOUT statement
attribute on all UNIX/Linux platforms. This was formerly supported
only on Windows.
For Teradata Users
------------------
When compiling an application on AIX for use with the driver for the
Teradata database, you must use the -brtl option. For example:
cc -o pgm pgm.o -brtl -lodbc
or
ld -o pgm -brtl pgm.o -lodbc
For Users of the Driver for Apache Hive(TM)
-------------------------------------------
The following are notes, known problems, and restrictions with the
driver. These restrictions are based on using Apache Hive 0.10.0; other
versions of Apache Hive will have their own restrictions. You may
find a more complete listing of Apache Hive known issues and limitations
for your version of Apache Hive in the Apache Hive user
documentation here:
https://cwiki.apache.org/confluence/display/Hive/Home
Note that Apache Hive is not designed for OLTP workloads and does not
offer real-time queries or row-level updates. Apache Hive is instead
designed for batch type jobs over large data sets with high latency.
Known Issues for Apache Hive(TM)
-------------------------------
* No support for row-level inserts, updates, or deletes
* No difference between "NULL" and null values
* For HiveServer1 connections, no support for multiple simultaneous connections
per port
* For HiverServer1 connections, no support for user-level authentication
* For HiveServer1 connections, no support for cancelling a running query
HiveQL
------
Apache Hive uses HiveQL, which provides much of the functionality of
SQL, but has some limitation syntax differences. For more information,
refer to the Hive Language Manual.
https://cwiki.apache.org/confluence/display/Hive/LanguageManual.
* A single quote within a string literal must be escaped
using a \ instead of using a single quote.
* Numeric values specified in scientific notation are not supported
in Apache Hive 0.7.1.
* Apache Hive supports UNION ALL statements only when embedded in a
subquery. For example,
SELECT * FROM (SELECT integercol FROM itable UNION ALL
SELECT integercol FROM gtable2) result_table
* Join support is limited to equi-joins.
Driver Defects Resolved
-----------------------
PSC00093392 The driver took a long time to get the catalog of tables
for a typical application.
Notes for the Driver for Apache Hive(TM)
----------------------------------------
* Apache Hive does not support transactions, and by default, the
Driver for Apache Hive reports that transactions are not supported.
However, some applications will not operate with a driver that reports
transactions are not supported. The Transaction Mode connection option
allows you to configure the driver to report that it supports
transactions. In this mode, the driver ignores requests to enter manual
commit mode, start a transaction, or commit a transaction and return
success. Requests to rollback a transaction return an error regardless
of the transaction mode specified.
* The binary data type is not supported with HiveServer2.
For Users of the Impala Wire Protocol Driver
-------------------------------------------
The following are notes, known problems, and restrictions with the
driver. These restrictions are based on using Cloudera Impala server 1.0; other
versions of Impala will have their own restrictions. You may
find a more complete listing of Impala known issues and limitations
for your version of Cloudera Impala in the Cloudera Impala user
documentation here:
http://www.cloudera.com/content/support/en/documentation.html
Note that Impala is not designed for OLTP workloads and does not
offer real-time queries or row-level updates. Impala is instead
designed for batch type jobs over large data sets with high latency.
Known Issues for Cloudera Impala
-------------------------------
* No support for transactions
* No support for canceling a running query
* No support for row-level inserts, updates, or deletes
* No support for cursors or scrollable cursors
* No support for prepared statements
Notes for the Impala Wire Protocol driver
-----------------------------------------
The Impala server uses the default port number 21050 unless changed by the system
administrator. Use this port number when configuring your driver, or consult with
your system administrator.
Do not use port number 21000 that is provided in the Beeswax and Cloudera
ODBC driver version 1.2 documentation, unless your system administrator has
designated this as the port number for your connection. Using this port number
will return a connection error.
For AIX Users
------------------------------
Some IBM AIX C compilers, such as xlc 3.1.4, do not support the use
of C++ build binaries. C developers on AIX should consult their
compiler documentation and verify that their AIX C compiler supports
the use of C++ shared libraries or the application could be unstable.
Unexpected behavior may occur randomly if the LIBPATH variable
exceeds 178 characters AND the ORACLE_HOME variable is relatively
long. To resolve this, create a shorter symbolic link for
ORACLE_HOME.
For dBASE Users
---------------
On UNIX and Linux platforms, dBASE table names (file names) are
case-sensitive and the case is retained in SQL commands. Column
names are case-sensitive also, but are upper-case in SQL commands
unless they are quoted with the identifier quote character.
For Oracle Users
-----------------------
If you are using Oracle 8.1.7, you must have the 8.1.7.1 server patch
installed. Otherwise, you may receive the Oracle error:"ORA-03120:
two-task conversion routine: integer overflow" when fetching LOB data.
SQLProcedures and SQLProcedureColumns now include functions/procedures
from Oracle packages. They are denoted in the result set as
PackageName.ProcedureName for the PROCEDURE_NAME.
To use static scrollable cursors with result sets containing long
columns, you must set EnableStaticCursorsForLongData (ESCLD) to 1
(EnableStaticCursorsForLongData=1) in the data source entry of the
Registry or in a connection string. The default setting is 0.
You must have a complete installation of the Oracle 8i client software
for the Oracle (client) driver to operate properly when accessing
remote Oracle 8i servers 8.0.5 or higher. Be sure that you have
installed one of the following products:
Oracle 8.1.6:
Oracle 8i Client 8.1.6--Installation Type: Programmer
Oracle 8.1.7:
Oracle 8i Client 8.1.7--Installation Type: Programmer
NOTES: On Linux, you must use the Oracle Net8 Client version 8.1.6.1.
For Text Users
--------------
Restriction: When the Text driver encounters an invalid file, you may
receive duplicate or multiple errors.
Documentation
PROGRESS DATADIRECT CONNECT SERIES FOR ODBC DOCUMENTATION SET
-------------------------------------------------------------
The Progress DataDirect Connect Series for ODBC documentation set is available
via product and data source tiles from the Progress Information Hub:
https://docs.progress.com
You can access the online help system directly via the HTML redirect in the
installation Help directory.
Installed Files for 32-bit Drivers
This file list assumes a full installation of all 32-bit drivers and
documentation. Your installation may vary from this list depending on
driver availability for your platform.
The installer copies the following files and subdirectories to the
product installation directory, by default,
/opt/Progress/DataDirect/Connect_for_ODBC_71:
notices.txt Third-party vendor license agreement
odbc.csh Setup script for C shell
odbc.ini Sample odbc.ini file
odbcinst.ini Sample odbcinst.ini file
odbc.sh Setup script for Bourne shell
IVODBC.LIC DataDirect license file
ODBCFIXES.TXT List of fixes since last release
ODBCREADME.TXT This file
/adminhelp: [Linux only]
help.html Administrator HTML help system entry file
wwhsec.htm HTML help system support file
unixadmin*.* Content files for the HTML help system
/bin:
bind27 DB2 bind utility
ivtestlib Test application to check that required
libraries are present and loadable
/bind:
/LUW/DDODBC_LUW.lst DB2 list files for Linux/UNIX/Windows
/LUW/DDOC510A.bnd
/LUW/DDOC510B.bnd
/LUW/DDOC510C.bnd
/LUW/DDOR510A.bnd
/LUW/DDOR510B.bnd
/LUW/DDOR510C.bnd
/LUW/DDOS510A.bnd
/LUW/DDOS510B.bnd
/LUW/DDOS510C.bnd
/LUW/DDOU510A.bnd
/LUW/DDOU510B.bnd
/LUW/DDOU510C.bnd
/iSeries/DDODBC_400.lst DB2 list files for iSeries
/iSeries/DDOC510A.bnd
/iSeries/DDOC510B.bnd
/iSeries/DDOC510C.bnd
/iSeries/DDON510A.bnd
/iSeries/DDON510B.bnd
/iSeries/DDON510C.bnd
/iSeries/DDOR510A.bnd
/iSeries/DDOR510B.bnd
/iSeries/DDOR510C.bnd
/iSeries/DDOS510A.bnd
/iSeries/DDOS510B.bnd
/iSeries/DDOS510C.bnd
/iSeries/DDOU510A.bnd
/iSeries/DDOU510B.bnd
/iSeries/DDOU510C.bnd
/iSeries/DDOV5R2.savf
/iSeries/DDOV5R3.savf
/iSeries/DDOV5R4.savf
/iSeries/DDOV6R1.savf
/iSeries/DDOV7R1.savf
/iSeries/CfODBC iSeries Manual Package Creation Instructions.txt
/zOS/DDODBC_MVS.LST DB2 list files for z/OS
/zOS/CNTLFILE.xmit
/zOS/DBRMFILE.xmit
/zOS/DDOC510A.bnd
/zOS/DDOC510B.bnd
/zOS/DDOC510C.bnd
/zOS/DDOR510A.bnd
/zOS/DDOR510B.bnd
/zOS/DDOR510C.bnd
/zOS/DDOS510A.bnd
/zOS/DDOS510B.bnd
/zOS/DDOS510C.bnd
/zOS/CfODBC zOS Manual Package Creation Instructions.txt
/help:
ConnectforODBCHelp.html HTML redirect to online help system
drda_connect.txt Help text for the DB2 Wire Protocol
SQLDriverConnect dialog
gplm_connect.txt Help text for the Greenplum Wire Protocol
SQLDriverConnect dialog
hive_connect.txt Help text for the Driver for Apache Hive
SQLDriverConnect dialog
ifcl_connect.txt Help text for the Informix Wire Protocol
SQLDriverConnect dialog
mysql_connect.txt Help text for the MySQL Wire Protocol
SQLDriverConnect dialog
openedge_connect.txt Help text for the Progress OpenEdge Wire
Protocol
SQLDriverConnect dialog
oraclewp_connect.txt Help text for the Oracle Wire Protocol
SQLDriverConnect dialog
postgresql_connect.txt Help text for the PostgreSQL Wire Protocol
SQLDriverConnect dialog
sqlserverwp_connect.txt Help text for the SQL Server Wire Protocol
SQLDriverConnect dialog
sqlsrv_connect.txt Help text for the SQL Server Legacy Wire
Protocol SQLDriverConnect dialog
tds_connect.txt Help text for the Sybase Wire Protocol
SQLDriverConnect dialog
sybaseiq_connect.txt Help text for the Sybase Wire Protocol
SQLDriverConnect dialog
informix_connect.txt Help text for the Informix SQLDriverConnect
dialog
oracle_connect.txt Help text for the Oracle SQLDriverConnect
dialog
teradata_connect.txt Help text for the Teradata SQLDriverConnect
dialog
/include:
odbcinst.h Include files
qesqlext.h
sql.h
sqlext.h
sqltypes.h
sqlucode.h
sqlunx.h
/java/lib:
sforce.jar Java components for the Salesforce driver
/lib:
Resource library file names end in r; setup library file names end in s.
The resource and setup libraries are for use by the LINUX ODBC
Administrator and appear in the file list ONLY on Linux platforms.
ivase27.so Sybase Wire Protocol driver
ivase27r.so
ivdb227.so DB2 Wire Protocol driver
ivdb227r.so
ivdbf27.so dBASE driver
ivdbf27r.so
ivgplm27.so Greenplum Wire Protocol driver
[DataDirect Connect XE for ODBC only]
ivgplm27r.so
ivhive27.so Driver for Apache Hive [DataDirect
Connect XE for ODBC only]
ivifcl27.so Informix Wire Protocol driver
ivifcl27r.so
ivinf27.so Informix driver
ivimpala27.so Impala Wire Protocol driver
ivimpala27r.so
ivmsss27.so SQL Server Legacy Wire Protocol driver
ivmsss27r.so
ivmsss27s.so
ivmsssdlg27.so SQL Server Legacy Wire Protocol driver
ivmysql27.so MySQL Wire Protocol driver
ivor827.so Oracle driver
ivor827r.so
ivor827s.so
ivora27.so Oracle Wire Protocol driver
ivora27r.so
ivpsql27.so PostgreSQL Wire Protocol driver
ivpsql27r.so
ivoe27.so Progress OpenEdge Wire Protocol driver
ivoe27r.so
ivsfrc27.so Salesforce driver
[DataDirect Connect XE for ODBC only]
ivsqls27.so SQL Server Wire Protocol driver
ivsyiq27.so Sybase IQ Wire Protocol driver
[DataDirect Connect XE for ODBC only]
ivtera27.so Teradata driver
[DataDirect Connect XE for ODBC only]
ivtera27r.so
ivtera27s.so
ivtrc27.so DataDirect trace library
ivtrn27.so DataDirect sample translation library
ivtxt27.so Text driver
ivtxt27r.so
libivicu27.so Unicode conversion tables [.a on AIX]
libivtls27.so TLS/SSL support file (OpenSSL library
version 1.1.1t) [.a on AIX]
libodbc.so ODBC Driver Manager [.a on AIX]
libodbcinst.so ODBC Installer [.a on AIX]
odbc.so ODBC Driver Manager (dynamically loadable)
[AIX only]
odbccurs.so ODBC Cursor library
odbcinst.so ODBC Installer (dynamically loadable)
[AIX only]
/locale/en_US/LC_MESSAGES:
ivase27.mo Sybase Wire Protocol driver message file
ivase27.po Sybase Wire Protocol driver message source
ivdb227.mo DB2 Wire Protocol driver message file
ivdb227.po DB2 Wire Protocol driver message source
ivdbf27.mo dBASE driver message file
ivdbf27.po dBASE driver message source
ivgplm27.mo Greenplum Wire Protocol driver message file
ivgplm27.po Greenplum Wire Protocol driver message source
ivhive27.mo Driver for Apache Hive message file
ivhive27.po Driver for Apache Hive message source
ivifcl27.mo Informix Wire Protocol driver message file
ivifcl27.po Informix Wire Protocol driver message source
ivimpala.mo Impala Wire Protocol driver message file
ivimpala.po Impala Wire Protocol driver message source
ivinf27.mo Informix client driver message file
ivinf27.po Informix client driver message source
ivmsss27.mo SQL Server Legacy Wire Protocol driver message
file
ivmsss27.po SQL Server Legacy Wire Protocol driver message
source
ivmysql27.mo MySQL Wire Protocol driver message file
ivmysql27.po MySQL Wire Protocol driver message source
ivor827.mo Oracle driver message file
ivor827.po Oracle driver message source
ivora27.mo Oracle Wire Protocol driver message file
ivora27.po Oracle Wire Protocol driver message source
ivpsql27.mo PostgreSQL Wire Protocol driver message file
ivpsql27.po PostgreSQL Wire Protocol driver message source
ivoe27.mo Progress OpenEdge Wire Protocol driver message
file
ivoe27.po Progress OpenEdge Wire Protocol driver message
source
ivsfrc27.mo Salesforce driver message file
ivsfrc27.po Salesforce driver message source
ivsqls27.mo SQL Server Wire Protocol driver message
file
ivsqls27.po SQL Server Wire Protocol driver message
source
ivsyiq27.mo Sybase IQ Wire Protocol driver message file
ivsyiq27.po Sybase IQ Wire Protocol driver message source
ivtera27.mo Teradata driver message file
ivtera27.po Teradata driver message source
ivtxt27.mo Text driver message file
ivtxt27.po Text driver message source
odbc.m ODBC Driver Manager message file
odbc.po ODBC Driver Manager message source
/samples:
/bulk/bulk Bulk application
/bulk/bulk.c Bulk example source
/bulk/bulk.mak Bulk example make file
/bulk/bulk.txt Bulk example description
/bulk/ddlogging.properties Log configuration file for the
Salesforce driver
/bulkstrm/bulk.cpp Bulk streaming example source
/bulkstrm/bulk.hpp Bulk streaming example header
/bulkstrm/bulkstrm Bulk streaming example application
/bulkstrm/bulkstrm.txt Bulk streaming example description
/bulkstrm/main.cpp Bulk streaming example source
/bulkstrm/msgprintf.hpp Bulk streaming example header
/bulkstrm/streambulk.mak Bulk streaming example make file
/bulkstrm/ddlogging.properties Log configuration file for the
Salesforce driver
/demo/demoodbc Demo application
/demo/demoodbc.c Demo source
/demo/driver_connect Demo SQLDriverConnect application
/demo/driver_connect.cc Demo SQLDriverConnect source
/demo/driver_connect.txt Demo SQLDriverConnect description
/demo/empdb2.sql DB2 SQL statements to populate the demo
application EMP table
/demo/empinformix.sql Informix SQL statements to populate the demo
application EMP table
/demo/emporacle.sql Oracle SQL statements to populate the demo
application EMP table
/demo/empsqlsrv.sql SQL Server SQL statements to populate the
demo application EMP table
/demo/empsybase.sql Sybase SQL statements to populate the demo
application EMP table
/demo/Makefile Demo application make file
/demo/EMP.DBF Sample dBASE file
/demo/EMP.DBT
/demo/QEDBF.INI Schema information for the sample dBASE
file
/demo/emptext.txt Sample text table
/demo/QETXT.INI Schema information for the sample text file
/demo/demoodbc.txt Demo application description
/example/example Example application
/example/example.c Example source
/example/example.h Example header
/example/example.mak Example make file
/example/example.txt Example description
/trn/makefile Translation Library example make file
/trn/readme.trn Translation Library example description
/trn/translat.c Translation Library example source file
/trn/ivtrn27.exp Translation shared library export file
[AIX only]
/tools:
ddextu License Extender utility
ddprocinfo Processor Information utility
odbcadmin ODBC Data Source Administrator [Linux only]
/wizards:
index.html
odbcperf.jar Performance wizard
/images/*.*
Installed Files for 64-bit Drivers
This file list assumes a full installation of all 64-bit drivers and
documentation. Your installation may vary from this list depending on
driver availability for your platform.
The installer copies the following files and subdirectories to the
product installation directory, by default,
/opt/Progress/DataDirect/Connect64_for_ODBC_71:
notices.txt Third-party vendor license agreement
odbc.csh Setup script for C shell
odbc.ini Sample odbc.ini file
odbcinst.ini Sample odbcinst.ini file
odbc.sh Setup script for Bourne shell
DDODBC.LIC DataDirect license file
ODBCREADME.TXT This file
ODBCFIXES.TXT List of fixes since last release
/adminhelp: [Linux only]
help.html Administrator HTML help system entry file
wwhsec.htm HTML help system support file
unixadmin*.* Content files for the HTML help system
/bin:
bind27 DB2 bind utility
ddtestlib Test application to check that required libraries
are present and loadable
/bind:
/LUW/DDODBC_LUW.lst DB2 list files for Linux/UNIX/Windows
/LUW/DDOC510A.bnd
/LUW/DDOC510B.bnd
/LUW/DDOC510C.bnd
/LUW/DDOR510A.bnd
/LUW/DDOR510B.bnd
/LUW/DDOR510C.bnd
/LUW/DDOS510A.bnd
/LUW/DDOS510B.bnd
/LUW/DDOS510C.bnd
/LUW/DDOU510A.bnd
/LUW/DDOU510B.bnd
/LUW/DDOU510C.bnd
/iSeries/DDODBC_400.lst DB2 list files for DB2 for i
/iSeries/DDOC510A.bnd
/iSeries/DDOC510B.bnd
/iSeries/DDOC510C.bnd
/iSeries/DDON510A.bnd
/iSeries/DDON510B.bnd
/iSeries/DDON510C.bnd
/iSeries/DDOR510A.bnd
/iSeries/DDOR510B.bnd
/iSeries/DDOR510C.bnd
/iSeries/DDOS510A.bnd
/iSeries/DDOS510B.bnd
/iSeries/DDOS510C.bnd
/iSeries/DDOU510A.bnd
/iSeries/DDOU510B.bnd
/iSeries/DDOU510C.bnd
/iSeries/DDOV5R2.savf
/iSeries/DDOV5R3.savf
/iSeries/DDOV5R4.savf
/iSeries/DDOV6R1.savf
/iSeries/DDOV7R1.savf
/iSeries/CfODBC iSeries Manual Package Creation Instructions.txt
/zOS/DDODBC_MVS.LST DB2 list files for z/OS
/zOS/CNTLFILE.xmit
/zOS/DBRMFILE.xmit
/zOS/DDOC510A.bnd
/zOS/DDOC510B.bnd
/zOS/DDOC510C.bnd
/zOS/DDOR510A.bnd
/zOS/DDOR510B.bnd
/zOS/DDOR510C.bnd
/zOS/DDOS510A.bnd
/zOS/DDOS510B.bnd
/zOS/DDOS510C.bnd
/zOS/CfODBC zOS Manual Package Creation Instructions.txt
/help:
ConnectforODBCHelp.html HTML redirect to online help system
drda_connect.txt Help text for the DB2 Wire Protocol
SQLDriverConnect dialog
gplm_connect.txt Help text for the Greenplum Wire Protocol
SQLDriverConnect dialog
hive_conect.txt Help text for the Driver for Apache Hive
SQLDriverConnect dialog
ifcl_connect.txt Help text for the Informix Wire Protocol
SQLDriverConnect dialog
impala_connect.txt Help text for the Imapal Wire Protocol
SQLDriverConnect dialog
mysql_connect.txt Help text for the MySQL Wire Protocol
SQLDriverConnect dialog
openedge_connect.txt Help text for the Progress OpenEdge Wire
Protocol SQLDriverConnect dialog
oraclewp_connect.txt Help text for the Oracle Wire Protocol
SQLDriverConnect dialog
postgresql_connect.txt Help text for the PostgreSQL Wire Protocol
SQLDriverConnect dialog
sqlserverwp_connect.txt Help text for the SQL Server Wire Protocol
SQLDriverConnect dialog
sqlsrv_connect.txt Help text for the SQL Server Legacy Wire
Protocol SQLDriverConnect dialog
tds_connect.txt Help text for the Sybase Wire Protocol
SQLDriverConnect dialog
oracle_connect.txt Help text for the Oracle SQLDriverConnect
dialog
sybaseiq_connect.txt Help text for the Sybase IQ SQLDriverConnect
dialog
teradata_connect.txt Help text for the Teradata SQLDriverConnect
dialog
/include:
odbcinst.h Include files
qesqlext.h
sql.h
sqlext.h
sqltypes.h
sqlucode.h
sqlunx.h
/java/lib:
sforce.jar Java components for the Salesforce driver
/lib:
Resource library file names end in r; setup library file names end in s.
The resource and setup libraries are for use by the Linux ODBC
Administrator and appear in the file list ONLY on Linux platforms.
ddase27.so Sybase Wire Protocol driver
ddase27r.so
dddb227.so DB2 Wire Protocol driver
dddb227r.so
ddgplm27.so Greenplum Wire Protocol driver[DataDirect
Connect64 XE for ODBC only]
ddgplm27r.so
ddhive27.so Driver for Apache Hive [DataDirect
Connect64 XE for ODBC only]
ddifcl27.so Informix Wire Protocol driver [not available
on Solaris x64]
ddifcl27r.so
ddimpala27.so Impala Wire Protocol driver [DataDirect
Connect64 XE for ODBC only]
ddimpala27r.so
ddmsss27.so SQL Server Legacy Wire Protocol driver
ddmsss27r.so
ddmsss27s.so
ddmysql27.so MySQL Wire Protocol driver
ddor827.so Oracle driver [not available on Red Hat
Linux for x64 or Solaris x64]
ddor827r.so
ddor827s.so
ddora27.so Oracle Wire Protocol driver
ddora27r.so
ddpsql27.so PostgreSQL Wire Protocol driver
ddpsql27r.so
ddoe27.so Progress OpenEdge Wire Protocol driver
ddsqls27.so SQL Server Wire Protocol driver
ddsfrc27.so Salesforce driver
[DataDirect Connect64 XE for ODBC only]
ddsyiq27.so Sybase IQ Wire Protocol driver [DataDirect
Connect64 XE for ODBC only]
ddtera27.so Teradata driver [DataDirect Connect64 XE for
ODBC only]
ddtera27r.so
ddtera27s.so
ddtrc27.so DataDirect trace library
ddtrn27.so DataDirect sample translation shared object
ddtxt27.so Text driver
ddtxt27r.so
libddicu27.so Unicode conversion tables [.a on AIX]
libddtls27.so TLS/SSL support file (OpenSSL library
version 1.1.1t) [.a on AIX]
libodbc.so ODBC Driver Manager [.a on AIX]
libodbcinst.so ODBC Installer [.a on AIX]
odbc.so ODBC Driver Manager (dynamically loadable)
[AIX only]
odbccurs.so ODBC Cursor library
odbcinst.so ODBC Installer (dynamically loadable)
[AIX only]
/locale/en_US/LC_MESSAGES:
ddase27.mo Sybase Wire Protocol driver message file
ddase27.po Sybase Wire Protocol driver message source
dddb227.mo DB2 Wire Protocol driver message file
dddb227.po DB2 Wire Protocol driver message source
ddgplm27.mo Greenplum Wire Protocol driver message file
ddgplm27.po Greenplum Wire Protocol driver message source
ddhive27.mo Driver for Apache Hive message file
ddhive27.po Driver for Apache Hive message source
ddifcl27.mo Informix Wire Protocol driver message file
[not available on Solaris x64]
ddifcl27.po Informix Wire Protocol driver message source
[not available on Solaris x64]
ddimpala27.mo Impala Wire Protocol message file
ddimpala27.po Impala Wire Protocol source file
ddmsss27.mo SQL Server Legacy Wire Protocol driver message
file
ddmsss27.po SQL Server Legacy Wire Protocol driver message
source
ddmysql27.mo MySQL Wire Protocol driver message file
ddmysql27.po MySQL Wire Protocol driver message source
ddoe27.mo Progress OpenEdge Wire Protocol driver message
file
ddoe27.po Progress OpenEdge Wire Protocol driver message
source
ddor827.mo Oracle driver message file [not available on
Red Hat Linux for x64 or Solaris x64]
ddor827.po Oracle driver message source [not available on
Red Hat Linux for x64 or Solaris x64]
ddora27.mo Oracle Wire Protocol driver message file
ddora27.po Oracle Wire Protocol driver message source
ddpsql27.mo PostgreSQL Wire Protocol driver message file
ddpsql27.po PostgreSQL Wire Protocol driver message source
ddsfrc27.mo Salesforce driver message file
ddsfrc27.po Salesforce driver message file source
ddsyiq27.mo Sybase IQ Wire Protocol driver message file
ddsyiq27.po Sybase IQ Wire Protocol driver message source
ddsqls27.mo SQL Server Wire Protocol driver message
file
ddsqls27.po SQL Server Wire Protocol driver message
source
ddtera27.mo Teradata driver message file
ddtera27.po Teradata driver message source [DataDirect
Connect64 XE for ODBC only]
ddtxt27.mo Text driver message file
ddtxt27.po Text driver message source
odbc.mo ODBC Driver Manager message file
odbc.po ODBC Driver Manager message source
/samples:
/bulk/bulk Bulk application
/bulk/bulk.c Bulk example source
/bulk/bulk.mak Bulk example make file
/bulk/bulk.txt Bulk example description
/bulk/ddlogging.properties Log configuration file for the Salesforce
driver
/bulkstrm/bulk.cpp Bulk streaming example source
/bulkstrm/bulk.hpp Bulk streaming example header
/bulkstrm/bulkstrm Bulk streaming example application
/bulkstrm/bulkstrm.txt Bulk streaming example description
/bulkstrm/ddlogging.properties Log configuration file for the Salesforce
driver
/bulkstrm/main.cpp Bulk streaming example source
/bulkstrm/msgprintf.hpp Bulk streaming example header
/bulkstrm/streambulk.mak Bulk streaming example make file
/demo/demoodbc Demo application
/demo/demoodbc.c Demo source
/demo/ddlogging.properties Log configuration file for the Salesforce
driver
/demo/driver_connect Demo SQLDriverConnect application
/demo/driver_connect.cc Demo SQLDriverConnect source
/demo/driver_connect.txt Demo SQLDriverConnect description
/demo/empdb2.sql DB2 SQL statements to populate the demo
application EMP table
/demo/empinformix.sql Informix SQL statements to populate the
demo application EMP table
/demo/emporacle.sql Oracle SQL statements to populate the demo
application EMP table
/demo/empsqlsrv.sql SQL Server SQL statements to populate the
demo application EMP table
/demo/empsybase.sql Sybase SQL statements to populate the demo
application EMP table
/demo/Makefile Demo application make file
/demo/demoodbc64.txt Demo description
/example/ddlogging.properties Log configuration file for the Salesforce
driver
/example/example Example application
/example/example.c Example source
/example/example.h Example header
/example/example.mak Example make file
/example/example64.txt Example description
/trn/makefile Translation Library example make file
/trn/readme.trn Translation Library example description
/trn/translat.c Translation Library example source file
/tools:
ddextu License Extender utility
ddprocinfo Processor Information utility
odbcadmin ODBC Data Source Administrator [Linux only]
/wizards:
index.html
odbcperf.jar Performance wizard
/images/*.*
~~~~~~~~~~~~~~~~~
February 2026
End of README