Powered by Zoomin Software. For more details please contactZoomin

DataDirect ODBC ReadMe

Progress OpenEdge ODBC 7.1.6 UNIX

  • Last Updated: May 8, 2026
  • 13 minute read
    • OpenAccess SDK
    • Documentation

     README
     Progress(R) DataDirect(R)
     Progress(R) DataDirect(R) for ODBC for 
     Progress OpenEdge(TM) Wire Protocol Driver

     UNIX and Linux Platforms (32- and 64-bit) 

     Release 7.1.6 
     February 2026


***********************************************************************
Copyright (C) 2026 Progress Software Corporation and/or its 
subsidiaries or affiliates. All Rights Reserved.

***********************************************************************

This README file contains information for Progress(R) DataDirect(R)  
for ODBC for OpenEdge(TM) Wire Protocol Driver. 

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
Third-party Components Compatibility Matrix
Changes Since 7.1.6 Release
Changes for 7.1.6 Release
Configuring Data Sources
Driver WorkAround Options
Documentation
Notes, Known Problems, and Restrictions 
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).


    Requirements

* The driver requires the following runtime libraries:

  - AIX: C/C++ runtime libraries version 16.1 or higher
  - Linux: C/C++ runtime libraries version GCC 2.12 or higher


    Installation Directory 
	   
* The default installation directory for the 32-bit driver is:

  /opt/Progress/DataDirect/ODBC_32Bit

* The default installation directory for the 64-bit driver is:

  /opt/Progress/DataDirect/ODBC_64Bit


      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


    Third-party Components Compatibility Matrix

For information about the third-party components that are installed with the 
product, refer to the ODBC Third-party Components Compatibility Matrix on the 
DataDirect Product Life Cycle page:
https://docs.progress.com/bundle/datadirect-product-life-cycle/page/topics/
datadirect_life_cycle/datadirect-product-life-cycle.html
  
  
    Changes Since 7.1.6 Release

ICU Library Upgrade (74.1) for AIX Platforms
--------------------------------------------
For AIX platforms, the ICU library files that are installed with the
product have been upgraded to version 74.1. As a part of this upgrade, 
the ICU library file names have changed for AIX platforms:
* For the 32-bit driver: From libivicu28.a to libivicu.a
* For the 64-bit driver: From libddicu28.a to libddicu.a

Notes:
* This upgrade does not apply to the other UNIX platforms.
* This upgrade is available starting in build 08.02.1072 of the ICU 
  library files.
* libivicu27.a (32-bit) and libddicu27.a (64-bit) will continue to 
  be included in the product package to support driver functionality.

Driver Manager Upgrade (8.0)
----------------------------
The Driver Manager has been upgraded to version 8.0. The purpose of 
this upgrade is to have all DataDirect for ODBC drivers use the latest 
version of the Driver Manager, which allows for faster security updates
and a consistent user experience. Note that the Driver Manager is 
backward compatible.

As part of this upgrade:
* The following ICU library files have been added to the product 
  package:
  - For UNIX: libivicu28.so (32-bit) and libddicu28.so (64-bit)
  - For Linux: libivicu.so (32-bit) and libddicu.so (64-bit)
* The trace library file names have been changed for both UNIX and Linux:
  - 32-bit: From ivtrc27.so to ivtrc28.so
  - 64-bit: From ddtrc27.so to ddtrc28.so

Note: libivicu27.so (32-bit) and libddicu27.so (64-bit) will continue to 
be included in the product package to support driver functionality.

The Driver Manager build included with the product is 08.02.1997 (U1987).

ICU Library Upgrade (74.1) for Linux Platforms
----------------------------------------------
For Linux platforms, the ICU library files that are installed with 
the product have been upgraded to version 74.1. As a part of this upgrade, 
the following ICU library files have been added to the product package:
libivicu.so (32-bit) and libddicu.so (64-bit).

This upgrade is available starting in build 08.02.0965 of the ICU library
files.

ODBC Cursor Library
-------------------
The product package no longer includes the ODBC Cursor library file 
(odbccurs.so) because it has some known security vulnerabilities that 
could potentially expose you to security risks.

Note: The installer program cannot remove the ODBC Cursor library file 
automatically while installing a new version of the driver. Remove it 
manually.      

Password Encryption Tool
------------------------
A Password Encryption Tool, called ddencpwd, is now included with the product
package. It encrypts passwords for secure handling in connection strings and
odbc.ini files. At connection, the driver decrypts these passwords and passes
them to the data source as required.

SSL Enhancement (3.0.9)
-----------------------
Note: OpenSSL library 3.0.9 has been replaced with a later version. For 
the latest information about the third-party components that are installed 
with the product, refer to the ODBC Third-party Components Compatibility 
Matrix on the DataDirect Product Life Cycle page:
https://docs.progress.com/bundle/datadirect-product-life-cycle/page/topics/
datadirect_life_cycle/datadirect-product-life-cycle.html.

The default version of the OpenSSL library has been upgraded to version 
3.0.9, which fixes the security vulnerabilities listed on the following 
page: https://www.openssl.org/news/vulnerabilities-3.0.html

This upgrade is available in build 08.02.0595 of the following OpenSSL 
library files: 
- On AIX: libivopenssl30.a (32-bit) and libddopenssl30.a (64-bit)
- On other platforms: ivopenssl30.so [.sl] (32-bit) and ddopenssl30.so (64-bit)

Notes:
* The driver supports the following OpenSSL 3.0 providers: Default and 
  FIPS.

* The FIPS provider is supported only on the following platforms: 
  Windows 64-bit, Linux 64-bit, and AIX 64-bit.

* The following connection options have been added to configure the 
  driver to use OpenSSL 3.0: Enable FIPS (EnableFIPS), OpenSSL Config File
  (OpenSSLConfigFile), and OpenSSL Provider Path (OpenSSLProviderPath).
  For more information on the new connection options and how to configure
  the driver to use OpenSSL 3.0, refer to the user's guide.
  
* When installing a new version of the product, the installer program will 
  automatically replace the OpenSSL 1.1.1 library files with the OpenSSL 3.0 
  library files in the install directory, which will impact all the DataDirect 
  ODBC drivers installed on a machine. Therefore:
  - If you are using multiple 7.1 drivers, upgrade all your drivers to the latest 
    version.
  - If you are using both 8.0 and 7.1 versions of the driver, copy the xxtls28.so
    file to a different location before installing a new version of the 7.1 driver. 
    Copy it back to the install directory once the installation is complete.


End of Support for OpenSSL 1.1.1
--------------------------------
The product no longer includes version 1.1.1 of the OpenSSL library. 
The library will reach the end of its product life cycle in September 2023
and will not receive any security updates after that. Note that continuing 
to use the library after September 2023 can potentially expose you to 
security vulnerabilities.

Note: As a result of this change, when installing a new version of the product, 
the installer program will automatically remove version 1.1.1 of the library 
from the install directory, which will impact all the DataDirect ODBC drivers 
installed on a machine.


Installer Upgrade
-----------------
The installer program has been enhanced to use a more modern and
secure technology. As a result of this enhancement: 

* The default installation location has been changed to:

  - For the 32-bit driver:
    /opt/Progress/DataDirect/ODBC_32Bit

  - For the 64-bit driver:
    /opt/Progress/DataDirect/ODBC_64Bit

* The new installer program does not support upgrading installations 
  made with earlier versions of the installer. You will need to 
  uninstall the existing installation and reinstall with the new 
  installer to resume upgrades in the same directory.

* The existing data sources cannot be used until they are 
  updated to point to the new installation location. To learn 
  how to update them, refer to the best practices documented
  at https://community.progress.com/s/.

* License keys you have used for the retired 7.1 installer cannot 
  be used with the new installer. Request new keys by either 
  contacting the Progress DataDirect Technical Support team or visiting
  https://www.progress.com/datadirect-connectors/request-upgrade.

Support for Azul Zulu JRE 11
----------------------------
The installer program has been enhanced to support Azul Zulu JRE 11.
As a result of this change, the installer has ended support for platforms 
that do not support Java SE 8 or higher. The installer supports the following 
operating systems after the enhancement:

* UNIX/Linux:
  - Any operating system on a machine using a JRE that is Java SE 8 or 
    higher (LTS version), including Oracle JDK, OpenJDK, and IBM SDK (Java) 
    distributions.
  
Important: These changes do not affect the operating system requirements of 
the driver.

Support for SQLCancel Function for SELECT Statements with OpenEdge V12.4 
and Higher
-------------------------------------------------------------------------
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.

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.

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.

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.    

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.


    Changes for 7.1.6 Release

CryptoLibName and SSLLibName Connection Options
------------------------------------------------
The new CryptoLibName and SSLLibName connection options allow you to 
designate the OpenSSL libraries used when SSL is enabled.
 
 
    Notes, Known Problems, and Restrictions 

Specifying values for the same connection option multiple times
--------------------------------------------------------------- 
The driver does not support specifying values for the same connection 
option multiple times in a connection string or DSN. If a value is 
specified using the same attribute multiple times or using both 
long and short attributes, the connection may fail or the driver may 
not behave as intended.

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. 

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 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.

	
    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.

      
    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 the 32-bit Driver
	 
This file list assumes a full installation of the 32-bit driver and 
documentation. 

The installer copies the following files and subdirectories to the 
product installation directory, by default:

/opt/Progress/DataDirect/ODBC_32Bit:

/<install_dir>/:
----------------
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
license.txt                      End User License Agreement


/bin/:
------
ivtestlib                        Test application to check that required 
                                 libraries are present and loadable


/FIXES/:
--------
fixes7.1.txt                     List of fixes since last release


/help/:
------- 
*.html                           HTML redirects to driver help systems


/include/:
----------
odbcinst.h                       Include files
qesqlext.h
sql.h
sqlext.h
sqltypes.h
sqlucode.h
sqlunx.h


/install/:
---------
*.*                              Files associated with the installer program


/jre/:
------
*.*                              Files associated with the installed JRE


/lib/:
------
ivoe27.so                        OpenEdge Wire Protocol driver
ivopenssl30.so                   TLS/SSL support file (OpenSSL library 
                                 version 3.0) [libivopenssl30.a on AIX]  
ivtrc28.so                       DataDirect trace library
libivicu.a                       Unicode conversion tables for AIX platforms
libivicu.so                      Unicode conversion tables for Linux platforms
libivicu27.so                    Unicode conversion tables [.a on AIX]
libivicu28.so                    Unicode conversion tables for all UNIX 
                                 platforms except for AIX
libodbc.so                       ODBC Driver Manager 
libodbcinst.so                   ODBC Installer
								
								
/locale/en_US/LC_MESSAGES/:
--------------------------
ivoe27.mo                        OpenEdge Wire Protocol driver message 
                                 file
ivoe27.po                        OpenEdge Wire Protocol driver message 
                                 file source
odbc.m                           ODBC Driver Manager message file
odbc.po                          ODBC Driver Manager message source


/NOTICES/:
----------
ODBC for OpenEdge
v7.1.6 notices.txt               Third-party vendor license agreements	


/READMES/:
----------
ODBC for OpenEdge
v7.1.6 readme.txt	               This file


/samples/bulk/:
---------------
bulk                             Bulk application
bulk.c                           Bulk example source
bulk.mak                         Bulk example make file
bulk.txt                         Bulk load example readme 
ddlogging.properties             Log configuration file for the 
                                 OpenEdge Wire Protocol driver


/samples/bulkstrm/:
------------------
bulkstrm                         Bulk streaming example application
bulk.cpp                         Bulk streaming example source
bulk.hpp                         Bulk streaming example header
bulkstrm.txt                     Bulk streaming description
ddlogging.properties             Log configuration file for the
                                 OpenEdge Wire Protocol driver
main.cpp                         Bulk streaming example source file
msgprintf.hpp                    Bulk streaming example header file
streambulk.mak                   Bulk streaming example make file


/samples/example/:								  
------------------						  
example                          Example application
example.c                        Example source
example.h                        Example header
example.mak                      Example make file
ddlogging.properties             Log configuration file for the 
                                 OpenEdge Wire Protocol driver
								 
								 
/tools/:
--------
ddencpwd                         Password Encryption Tool
ddextu                           License Extender utility
ddprocinfo                       Processor Information utility


/uninstall/:
------------
*.*                              Files used to uninstall the product
							

    Installed Files for the 64-bit Driver
	 
This file list assumes a full installation of the 64-bit driver and 
documentation. 

The installer copies the following files and subdirectories to the 
product installation directory, by default:

/opt/Progress/DataDirect/ODBC_64Bit:


/<install_dir>/:
-------------
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
license.txt                      End User License Agreement


/bin/:
------
ddtestlib                        Test application to check that required 
                                 libraries are present and loadable


/FIXES/:
--------
fixes7.1.txt                     List of fixes since last release


/help/:
------- 
*.html                           HTML redirects to driver help systems


/include/:
----------
odbcinst.h                       Include files
qesqlext.h
sql.h
sqlext.h
sqltypes.h
sqlucode.h
sqlunx.h


/install/:
---------
*.*                              Files associated with the installer program


/jre/:
------
*.*                              Files associated with the installed JRE


/lib/:
------
ddoe27.so                        OpenEdge Wire Protocol driver
ddopenssl30.so                   TLS/SSL support file (OpenSSL library 
                                 version 3.0) [libddopenssl30.a on AIX]
ddtrc28.so                       DataDirect trace library
fips.so                          Support file for FIPS provider (OpenSSL 
                                 library version 3.0) 
libddicu.a                       Unicode conversion tables for AIX platforms
libddicu.so                      Unicode conversion tables for Linux platforms
libddicu27.so                    Unicode conversion tables [.a on AIX]
libddicu28.so                    Unicode conversion tables for all UNIX 
                                 platforms except for AIX
libodbc.so                       ODBC Driver Manager [.a on AIX]
libodbcinst.so                   ODBC Installer [.a on AIX]
odbccurs.so                      ODBC Cursor library [.a on AIX]
openssl.cnf                      Configuration file for FIPS provider
                                 (OpenSSL library version 3.0)


/locale/en_US/LC_MESSAGES/:
---------------------------
ddoe27.mo                        OpenEdge Wire Protocol driver message 
                                 file
ddoe27.po                        OpenEdge Wire Protocol driver message
                                 file source
odbc.m                           ODBC Driver Manager message file
odbc.po                          ODBC Driver Manager message source


/NOTICES/:
----------
ODBC for OpenEdge
v7.1.6 notices.txt               Third-party vendor license agreements	


/READMES/:
----------
ODBC OpenEdge
v7.1.6 readme.txt	               This file


/samples/bulk/:
---------------
bulk                             Bulk application
bulk.c                           Bulk example source
bulk.mak                         Bulk example make file
bulk.txt                         Bulk load example readme 
ddlogging.properties             Log configuration file for the 
                                 OpenEdge Wire Protocol driver


/samples/bulkstrm/:
------------------
bulkstrm                         Bulk streaming example application
bulk.cpp                         Bulk streaming example source
bulk.hpp                         Bulk streaming example header
bulkstrm.txt                     Bulk streaming description
ddlogging.properties             Log configuration file for the
                                 OpenEdge Wire Protocol driver
main.cpp                         Bulk streaming example source file
msgprintf.hpp                    Bulk streaming example header file
streambulk.mak                   Bulk streaming example make file


/samples/example/:  
------------------						  
example                          Example application
example.c                        Example source
example.h                        Example header
example.mak                      Example make file
ddlogging.properties             Log configuration file for the 
                                 OpenEdge Wire Protocol driver


/tools/:
--------
ddencpwd                         Password Encryption Tool
ddextu                           License Extender utility
ddprocinfo                       Processor Information utility


/uninstall/:
------------
*.*                              Files used to uninstall the product

  
  
~~~~~~~~~~~~~~~~~
February 2026
End of README.TXT
TitleResults for “How to create a CRG?”Also Available inAlert