Powered by Zoomin Software. For more details please contactZoomin

DataDirect ODBC ReadMe

Text ODBC 7.1.6 UNIX

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

     README
     Progress(R) DataDirect(R)
     Progress(R) DataDirect(R) for ODBC for Text(TM) Driver

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

     Release 7.1.6 
     January 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 Text(TM) Driver. 

This README file contains information not included in the DATADIRECT 
CONNECT(R) SERIES FOR ODBC documentation.


CONTENTS

Post-GA Product Announcements
Requirements
Installation Directory
Data Source and Platform Support 
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 installer program requires a JVM that is Java SE 11 or higher, including
  Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.

* 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
  - Solaris: C/C++ runtime libraries version 12.6 or higher 
  - IBM Power 8 (64-bit): C/C++ runtime libraries of GCC 2.17 or higher
  - Linux z/OS (64-bit): C/C++ runtime libraries of GCC 2.17 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  

  
    Changes Since 7.1.6 Release  
	
* 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 platforms and their
  file names have been updated:
  
  - AIX platforms
	- 32-bit product package: From libivicu28.a to libivicu.a
	- 64-bit product package: From libddicu28.a to libddicu.a 
  Note - This upgrade is available starting in build 08.02.1072 of the ICU 
  library files.
	
  - Linux platforms
	- 32-bit product package: From libivicu28.so to libivicu.so
	- 64-bit product package: From libddicu28.so to libddicu.so
  Note - This upgrade is available starting in build 08.02.0965 of the ICU 
  library files.
	
  - Solaris platforms (Sparc)
	- 32-bit product package: From libivicu28.so to libivicu.so
	- 64-bit product package: From libddicu28.so to libddicu.so
  Note - This upgrade is available starting in build 08.02.1799 of the ICU 
  library files.	
	
  - Limited availability plaforms (IBM Power 8 and Linux z/OS) 
	- 64-bit product package: From libddicu28.so to libddicu.so
  Note - This upgrade is available starting in build 08.02.1799 of the ICU 
  library files. 
  
  As part of the ICU 74.1 upgrade, the compiler and runtime versions for the 
  driver have been changed to the following:
  
  - For AIX platforms, the compiler version has been upgraded to xlclang++ 16.1.
    As a result, you must have C/C++ runtime libraries of 16.1 or higher
	installed to run the driver. 

  - For Linux platforms, the compiler version has been upgraded to GCC 7.3.1. 
    As a result, you must have C/C++ runtime libraries of GCC 2.12 or higher
	installed to run the driver. 
	
  - For Solaris platforms, the compiler version has been upgraded to Oracle 
    Developer Studio 12.6. As a result, you must have C/C++ runtime libraries 
	of 12.6 or higher installed to run the driver. 

  - For limited availability platforms such as Linux z/OS (64-bit) and 
    IBM Power 8 (64-bit), the compiler version has been upgraded to GCC 7.3.1. 
	As a result, you must have C/C++ runtime libraries of GCC 2.17 or higher
	installed to run the driver.  	

JRE Requirement for the Installer
---------------------------------
The installer program now requires you to install a JRE that is Java SE 11 or
higher before running the installer. In earlier versions, the JRE used by the
installer program was included in the product. However, to avoid potential
security vulnerabilities, the installer program no longer includes a JRE.
Instead, the installer program uses the JRE in your environment to allow for
the most secure version of a JRE to be used.
 
Notes:
* This change does not affect the JVM requirements for the driver. For the latest 
  driver requirements, refer to the Product Compatibility Guide:
  https://docs.progress.com/bundle/datadirect-product-compatibility/resource/
  datadirect-product-compatibility.pdf
* The installer program cannot remove the already installed JRE files from the 
  install directory automatically. Remove them manually.


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

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.

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.

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.

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.

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.

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.


    Changes for 7.1.6 Release

No features introduced. 
 
 
    Notes, Known Problems, and Restrictions 

The following are notes, known problems, and restrictions with the 
7.1.6 release of the driver.

Text Driver Against Invalid Files
---------------------------------
Restriction: When the Text driver encounters an invalid file, you may 
receive duplicate or multiple errors.

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.

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


/lib/:
------
ivtxt27.so                       The Text driver  
ivtrc28.so                       DataDirect trace library
libivicu.a                       Unicode conversion tables for AIX platforms
libivicu.so                      Unicode conversion tables for Linux and Solaris
                                 platforms
libivicu27.so                    Unicode conversion tables [.a on AIX]
libodbc.so                       ODBC Driver Manager 
libodbcinst.so                   ODBC Installer
								
								
/locale/en_US/LC_MESSAGES/:
--------------------------
ivtxt27.mo                       The Text driver message file
ivtxt27.po                       The Text driver message 
                                 file source
odbc.m                           ODBC Driver Manager message file
odbc.po                          ODBC Driver Manager message source


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


/READMES/:
----------
ODBC for Text   
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 
                                 The Text 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
                                 Text 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 
                                 Text 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


/lib/:
------
ddtxt27.so                       The Text driver
ddtrc28.so                       DataDirect trace library 
libddicu.a                       Unicode conversion tables for AIX platforms
libddicu.so                      Unicode conversion tables for Linux and Solaris 
                                 platforms 							   
libddicu27.so                    Unicode conversion tables [.a on AIX]
libodbc.so                       ODBC Driver Manager [.a on AIX]
libodbcinst.so                   ODBC Installer [.a on AIX]


/locale/en_US/LC_MESSAGES/:
---------------------------
ddtxt27.mo                       The Text driver message 
                                 file
ddtxt27.po                       The Text driver message
odbc.m                           ODBC Driver Manager message file
odbc.po                          ODBC Driver Manager message source


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


/READMES/:
----------
ODBC Text
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 
                                 Text 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
                                 Text 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 
                                 Text driver


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


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

  
  
~~~~~~~~~~~~~~~~~
January 2026
End of README.TXT


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