OpenAccess SDK 9.0.0
- Last Updated: May 8, 2026
- 14 minute read
- OpenAccess SDK
- Documentation
README
Progress(R) DataDirect(R)
DataDirect OpenAccess(tm) SDK
Version 9.0.0
November 2025
***********************************************************************
Copyright (c) 1995-2026 Progress Software Corporation and/or its
subsidiaries or affiliates. All rights reserved. DataDirect and
OpenAccess are registered trademarks of Progress Software
Corporation in the U.S. and other countries. Any other trademarks or
service marks contained herein are the property of their respective
owners.
***********************************************************************
This README file contains information about the following topics:
1. Post-GA Product Announcements
2. Requirements
3. Data Source and Platform Support
4. Changes for 9.0.0 Release
5. Installing OpenAccess SDK Server and IP SDK
6. Installing OpenAccess SDK Client for ODBC
7. Installing OpenAccess SDK Client for JDBC
8. OpenAccess SDK Server Notes
9. OpenAccess SDK Client for ODBC Notes
10. OpenAccess SDK Local Client for ODBC Notes
11. OpenAccess SDK Client for JDBC Notes
12. OpenAccess SDK Management Console/OpenAccess SDK Command Line
Notes
13. Migrating from OpenAccess SDK 8.1.0 to 9.0.0
14. OpenAccess SDK Documentation
15. Contacting Progress DataDirect Customer Support
1. 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).
2. Requirements
* The JDBC Client requires a Java Virtual Machine (JVM) that is Java SE 8 or
higher, including Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.
A supported JVM must be defined on your system path.
* The ODBC Client, Local Client for ODBC, and OpenAccess SDK Server require
the following components:
* Runtime libraries:
- For Windows 32-bit: Microsoft Visual C/C++ redistributable (x86)
version 14.42.34438 or higher
- For Windows 64-bit: Microsoft Visual C/C++ redistributable
(x86 and x64) version 14.42.34438 or higher
- For UNIX/Linux: C/C++ runtime libraries of GCC 8.5 or higher
* Microsoft Data Access Components (MDAC):
- For 32-bit Windows systems, version 2.6 or later is required.
- For 64-bit Windows systems, version 2.8 or later is required.
Depending on the version of your Windows operating system, these
components may already be installed. You can download a utility that
determines whether MDAC is installed and its version from the following
Microsoft site:
http://msdn.microsoft.com/en-us/data/aa937730.aspx
You can also download MDAC from the same site.
3. 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.
4. Changes for 9.0.0 Release
Enhancements
------------
* The default version of the OpenSSL library has been upgraded to version
3.0.16, 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.1440 of the following OpenSSL
library files: openssl900.dll (Windows) and openssl900.so (Linux).
* 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 been changed to:
- For Windows: ivicu.dll (32-bit) and ddicu.dll (64-bit)
- For Linux: libivicu.so (32-bit) and libddicu.so (64-bit)
This upgrade is available starting in build 08.02.1072 of the ICU
library files.
* The SQLite library that is included in the product has been upgraded
to version 3.49.1.
* The ODBC Client, Local Client for ODBC, and OpenAccess SDK Server are
now compiled with a Visual Studio 2022 compiler for Windows platforms.
As a result, you must have Microsoft Visual C/C++ runtime version
14.42.34438 or higher on your machine to run these products.
* The ODBC Client, Local Client for ODBC, and OpenAccess SDK Server are
now compiled with a GCC 8.5 compiler for Linux platforms. As a result,
you must have C/C++ runtime libraries of GCC 8.5 or higher to run these
products.
Changed Behavior
----------------
* The default port numbers for the OpenAccess SDK agent and services have
been changed to:
- OpenAccess SDK Agent: 20091
- OpenAccess SDK C Service: 20092
- OpenAccess SDK C_SQL Service: 20093
- OpenAccess SDK Java Service: 20094
- OpenAccess SDK Java_SQL Service: 20095
- Open Access SDK Net Service (Windows only): 20096
* The TLSv1.1 and TLSv1.0 cryptographic protocols have been deprecated.
These protocols are no longer considered secure and, therefore, are no
longer recommended for use. However, OpenAccess SDK still supports TLSv1.1
and TLSv1.0 for legacy database servers that do not support more secure
protocols.
* The LDAP functionality is no longer supported. As a result, the OpenLDAP
library files are no longer included in the product.
* The Solaris and HP-UX platforms have been deprecated.
* The ADO and ADO.NET clients are currently available only in
OpenAccess SDK 8.1. However, they are compatible with the
OpenAccess SDK 9.0 server.
* The AIX platform is currently not supported with OpenAccess 9.0.
* The runtime library file, MSVCR100.dll, is no longer included in the
OpenAccess SDK Server package. Install Microsoft Visual C/C++ runtime
version 14.42.34438 or higher to use the product.
* The license.txt file is no longer included in the product package.
* The ODBC Cursor library file (odbccurs.so) is no longer included in
the product package because it has some known security vulnerabilities
that could potentially expose you to security risks.
5. Installing OpenAccess SDK Server and IP SDK
Installing OpenAccess SDK Server on Windows
-----------------------------------------------------------------------
* The OpenAccess SDK Server installer prompts you for the user who is
allowed to administer the OpenAccess SDK Server using the OpenAccess
SDK Manager. The user you specify must have administrator rights.
If the specified user does not have administrator rights, administration
of your OpenAccess SDK environment is severely limited (all actions on
OpenAccess SDK services fail).
NOTE: The installer does not check whether the user you enter has
administrator rights, so you must verify this before installation.
The User Account control (UAC) does not send a prompt before starting the
installation. To install a product that requires administrator privileges,
you must run it with "Run as administrator". Right-click on the
installer executable and choose "Run as Administrator."
* The installation occurs in two phases. In the first phase, the user
responds to the dialog boxes with the necessary installation
information. Then, the installer copies all the necessary software to
your workstation. The installer updates the necessary system
information. If a problem occurs during this phase, the installer
automatically rolls back.
The second phase attempts to start the OpenAccess SDK Agent service
and the OpenAccess SDK data access service. If a problem occurs during
this phase, the installation is not rolled back, and the user is
notified that the OpenAccess SDK Agent or OpenAccess SDK Data Access
service could not be started. Look in the oaserver.log file in the
temporary directory (%TEMP%) or the EventViewer for more detailed
information about the failure.
If the OpenAccess SDK Agent service could not be started, use one of
the OpenAccess SDK administration tools in off-line mode to change
the OpenAccess SDK Agent service configuration and restart the
OpenAccess SDK Agent service. In addition, restart the data access
service.
If the OpenAccess SDK data access service could not be started, use
one of the OpenAccess SDK administration tools to change the
OpenAccess SDK data access service configuration and restart the
OpenAccess SDK data access service.
* OpenAccess SDK installation through Remote Desktop Access and Terminal
Services is supported on all supported Windows platforms.
* Before uninstalling OpenAccess SDK Server, stop all OpenAccess SDK
Services. Use the OpenAccess SDK Administration Clients or the
Services Control Panel to stop any active OpenAccess SDK data access
services and the OpenAccess SDK Agent.
* If you are uninstalling the product and receive a failure, the
uninstall rolls back and the product remains installed. Check
the oaserver.log file in the temporary directory (%TEMP%) for details
about the failure. If the oaserver.log file contains "OpenAccess SDK
Error 3141: Failed to unregister the OS service because it is not
stopped", launch the uninstall again. This failure can occur when
more time is required to stop the OpenAccess SDK services.
By the time the uninstall runs a second time,
the OpenAccess SDK services should be stopped.
* To test the OpenAccess SDK Server with the Java IP in a 64-bit
environment, you must use JDK 1.8 or higher.
Installing OpenAccess SDK Server on UNIX/Linux
----------------------------------------------
* Do not use spaces when specifying an OpenAccess SDK Agent name during
installation.
6. Installing OpenAccess SDK Client for ODBC
Installing OpenAccess SDK Client for ODBC on Windows
----------------------------------------------------
* Administrator rights are required to install the OpenAccess SDK Client for
ODBC. Launching the installer without having administrator rights results in
unexpected behavior.
NOTE: The installer does not generate an error message when you
install without having administrator rights. The User Account control (UAC)
does not send a prompt before starting the installation. To install a
product that requires administrator privileges, you must run it with
"Run as Administrator". Right-click on the installer executable and
choose "Run as Administrator."
* On 32-bit platforms, OpenAccess SDK Client for ODBC requires MDAC 2.7
Service Pack 1 or higher. This requirement is checked during
installation. If MDAC 2.7 Service Pack 1 is not installed, you can
download the appropriate version of MDAC from the Microsoft Web site.
* On 64-bit platforms, OpenAccess SDK Client for ODBC requires MDAC 2.8.
This requirement is checked during installation. If MDAC 2.8 is not
installed, you can download the appropriate version of MDAC from the
Microsoft Web site.
* Creating Quick Install images is not supported.
* If you want to install OpenAccess SDK 9.0.0 Client for ODBC on the same
machine as an OpenAccess SDK 8.1, 8.0 or 7.2 Client for ODBC, you must
install them into different directories.
* If you want to upgrade your OpenAccess SDK 8.1 Client to the OpenAccess
SDK 9.0.0 Client for ODBC, you must uninstall the OpenAccess SDK 8.1
Client before you install OpenAccess SDK 9.0.0 Client for ODBC.
7. Installing OpenAccess SDK Client for JDBC
Installing OpenAccess SDK Client for JDBC on all Platforms
----------------------------------------------------------
* If you want to install OpenAccess SDK 9.0.0 Client for JDBC on the same
machine as an OpenAccess SDK 8.1, 8.0 or 7.2 Client for JDBC and run them
side-by-side, you must install them into different directories.
Also, when you run your applications, make sure that your
CLASSPATH points to the correct OpenAccess SDK Client for JDBC
version.
* If you want to upgrade your OpenAccess SDK 8.1 Client to OpenAccess
SDK 9.0.0 Client for JDBC, you must uninstall the OpenAccess SDK 8.1
Client before you install the OpenAccess SDK 9.0.0 Client for JDBC.
* You must have rights to create files in the directory where you want
to install OpenAccess SDK Client for JDBC. Launching the installer
without having these rights generates an exception for every
file the installer attempts to save. You should make sure that there
is sufficient space on the volume and that you have rights to create
files.
Installing OpenAccess SDK Client for JDBC on UNIX/Linux
-------------------------------------------------------
* When you install OpenAccess SDK Client for JDBC on UNIX and Linux,
make sure that the DISPLAY environment variable is set correctly.
If you cannot set the DISPLAY variable or do not have a windowing
environment on UNIX or Linux, you can install OpenAccess SDK Client
for JDBC using a command line. For instructions, refer to the
section "Command-Line Installation" in the "OPENACCESS SDK
INSTALLATION GUIDE"
(https://docs.progress.com/category/datadirect-openaccess-sdk).
* The OpenAccess SDK Client for JDBC installer might have problems
displaying the correct size for windows, fonts, bullets, and so on,
depending on the X-Windows version and the JDK used during
installation.
Recommended Workaround: Install OpenAccess SDK Client for JDBC using
the command line.
* After installing OpenAccess SDK Client for JDBC on UNIX, execute the
following (or similar) command manually from the installation
directory:
chmod -R ugo+x install_Dir
where install_Dir is the directory where you installed the
OpenAccess SDK Client for JDBC. If you do not do this, you cannot
execute the shell scripts.
Uninstalling OpenAccess SDK Client for JDBC
-------------------------------------------
* To uninstall the OpenAccess SDK Client for JDBC, remove the
installation directory.
8. OpenAccess SDK Server Notes
Configuring the Thread-Pool Engine
----------------------------------
* To allow OpenAccess SDK Server to create the number of threads
specified by the ServiceMaxThreads attribute, make sure that you
have sufficient system resources (and that the UNIX kernel parameter
is configured correctly). If you do not have sufficient system
resources, OpenAccess SDK Server may not start, or may terminate or
hang client connections unexpectedly. If resource availability on
your system varies substantially depending on the time of day, we
recommend that you configure your OpenAccess SDK service with
ServiceMinThreads equal to ServiceMaxThreads. In that case, the
OpenAccess SDK service creates all required threads on startup and
does not try to acquire more thread-related resources while it is
running.
* On AIX, the value for ServiceMaxThreads must be equal to or less
than 512.
* When configuring an OpenAccess SDK service in threadpool mode, it is
recommended that you change the default value of
DatasourceThreadMaxRPC from 10 to 15 to avoid a context switch
during the connection process.
SSL Notes
---------
* In the SSL protocol, both the client and the server must generate
random data for keys and other secrets. The data must be generated
in such a way that a knowledgeable attacker cannot guess anything
about it. Numbers produced from traditional pseudo-random number
generators are not sufficient for security. OpenSSL has its own
cryptographic pseudo-random number generator, but it only provides
security if it has been "seeded" with enough random information.
A seed is a piece of data that is fed to the generator to get it
going. Given a single known seed at startup, the generator produces
a stream of predictable outputs. The seed must be a random number,
and it needs to be a truly unguessable piece of data of sufficient
length to thwart any possible guessing attacks. Usually, you need at
least 128 bits of data, where each bit is just as likely to be a 0
as a 1.
If you try to use OpenSSL without seeding the random number generator,
the library generates an error; however, the library is unable to
determine whether the seed you give it contains enough entropy. There
are hardware devices that do a good job of collecting it, including
most of the cryptographic accelerator cards. However, in many cases,
hardware is impractical because your software will be deployed across
a large number of clients, most of which have no access to such
devices.
Many UNIX-based operating systems now come with a random device that
provides entropy harvested by the operating system. On other UNIX
systems and on Windows systems, you can use tools
such as EGADS, a portable entropy collection system. OpenAccess SDK
has been tested with the EGADS tool.
Using the Java Service
----------------------
* When using an OpenAccess SDK service for Java on AIX (32-bit), export
LDR_CNTRL to specify USEREGS and MAXDATA. The MAXDATA setting is
required to allow the service to use more than 256 MB. For example:
export LDR_CNTRL=MAXDATA=0x50000000@USERREGS
A minimum of 5 segments (MAXDATA=0x50000000) must be used.
More information is available at:
https://www.ibm.com/support/knowledgecenter/SSYKE2_6.0.0/welcome/
welcome_javasdk_version.html
https://download.boulder.ibm.com/ibmdl/pub/software/dw/aix/es-aix_ll.pdf
* When using an OpenAccess SDK service for Java on AIX (64-bit), export
LDR_CNTRL to specify USEREGS. For example:
export LDR_CNTRL=USERREGS
More information is available at:
https://www.ibm.com/support/knowledgecenter/SSYKE2_6.0.0/welcome/
welcome_javasdk_version.html
Process Memory Usage Limit
--------------------------
* The OpenAccess SDK Service on AIX (32-bit) is built with 256 MB process
size limit. Use the LDR_CNTRL environment variable to set MAXDATA to
extend this limit. For example, to extend to 1 GB, set
MAXDATA=0x80000000:
export LDR_CNTRL=MAXDATA=0x80000000
More information is available at:
https://download.boulder.ibm.com/ibmdl/pub/software/dw/aix/es-aix_ll.pdf
9. OpenAccess SDK Local Client for ODBC Notes
Shortcut for the Management Console
-----------------------------------
* The shortcut for the Local Client for ODBC (32-bit) management
console currently points to the oaadmin81.msc file. You can update
the shortcut to point to the oaadmin90.msc file instead.
ODBC Development on UNIX Platforms
----------------------------------
* All of the ODBC Version 3.x Core Components that are required to
develop ODBC applications on UNIX are installed into the /include
directory of the OpenAccess SDK Client for ODBC installation.
Please read the license.txt file in the /include directory for
applicable licensing information regarding the ODBC Core Components.
Contact your Progress DataDirect Sales or Customer Support
representative if you have any questions.
Developing ODBC Applications Using Languages Other than C++
-----------------------------------------------------------
* OpenAccess SDK Client for ODBC is a C++ shared library. OpenAccess SDK
Client for ODBC can be used with any language that supports loading a
C++ shared library. However, if you are using a programming language
other than C++, there are additional steps you must take to ensure
that the C++ libraries are initialized correctly when loaded by
non-C++ compiled applications. If you are not using C++, consult your
compiler documentation for instructions on using C++ shared libraries
with your application.
SQLSetConnectAttr - SQL_ATTR_AUTOCOMMIT
------------------------------------
* Before switching the autocommit mode to SQL_AUTOCOMMIT_ON, the
application must explicitly commit or roll back transactions
with SQLEndTran; the Client does not automatically commit the
current transaction.
Customizing Error Messages During Localization on AIX
-----------------------------------------------------
The customization of the error messages in the ODBC Client on AIX
64-bit misses a flag in genmsg.sh.
Change the line
XARFLAGS="xv" to XARFLAGS="-X64 -xv"
10. OpenAccess SDK Local Client for ODBC Notes
Using the Java Service
----------------------
* When using an OpenAccess SDK service for Java on AIX (32-bit), export
LDR_CNTRL to specify USEREGS and MAXDATA. The MAXDATA setting is
required to allow the service to use more than 256 MB. For example:
export LDR_CNTRL=MAXDATA=0x50000000@USERREGS
A minimum of 5 segments (MAXDATA=0x50000000) should be used.
More information is available at:
https://www.ibm.com/support/knowledgecenter/SSYKE2_6.0.0/welcome/
welcome_javasdk_version.html
https://download.boulder.ibm.com/ibmdl/pub/software/dw/aix/es-aix_ll.pdf
* When using a OpenAccess SDK service for Java on AIX (64-bit), export
LDR_CNTRL to specify USEREGS. For example:
export LDR_CNTRL=USERREGS
More information is available at:
https://www.ibm.com/support/knowledgecenter/SSYKE2_6.0.0/welcome/
welcome_javasdk_version.html
11. OpenAccess SDK Client for JDBC Notes
Using Encryption and SSL on JDK 1.8 or higher
-----------------------------------------------
* Because of import control restrictions, the version of JCE policy
files that are bundled in JDK 1.8 or higher environment
allow "strong", but limited, cryptography to be used. To use
Encryption and Secure Socket Layer (SSL), you must install
"unlimited strength" policy files, which contain no restrictions
on cryptographic strengths.
Using encryption or SSL without these "unlimited strength" policy
files results in unexpected behavior, such as
"java.lang.SecurityException: Unsupported keysize or algorithm",
Internal Errors, or "NullPointerExceptions"
The demo certificates use strong encryption; therefore, you must
install "unlimited strength" policy files. To allow the JVM to pick
up these policy files, the jre/bin directory must be first in the
path.
Kerberos Issues
---------------
* The following web site lists some problems that may occur when
attempting a login and suggestions for solving them:
https://www.oracle.com/technetwork/java/javase/trouble-138361.html
Note especially that on Windows 32-bit and 64-bit editions, a Registry
change may be required when you get the following error message:
[DataDirect][OpenAccess SDK JDBC Driver]Authentication failed:
Miscellaneous failure, unspecified at the MGSS level.
"This exception is thrown when using native ticket cache on some
Windows platforms. Microsoft has added a new feature in which they no
longer export the session keys for Ticket-Granting Tickets (TGTs).
As a result, the native TGT obtained on Windows has an "empty" session
key and null EType. The affected platforms include: Windows Server
2003 and Windows XP SP3."
NOTE: This message is also valid for Windows 7/Vista/Server 2008/
Server 2008 R2/Server 2012/Windows 8.
Cancel Functionality
--------------------
* OpenAccess SDK 9.0.0 release does not support JDBC Cancel functionality
when the ServiceEncryptionAlgorithm attribute is set at the
OpenAccess SDK Server, or when you use Secure Socket Layer (SSL).
Connection method: setAutoCommit
--------------------------------
* Before switching to autocommit mode, the application must explicitly
commit or rollback transactions; the driver does not automatically
commit the current transaction.
12. OpenAccess SDK Management Console/OpenAccess SDK Command Line
Notes
* The OpenAccess SDK Management Console requires the Microsoft
Management Console (MMC) version 2.0 or higher.
* The OpenAccess SDK Management Console can be used with Remote Desktop
Access and Terminal Services on Windows.
* The supplied OpenAccess SDK Management Console/OpenAccess SDK
Management Command Line is 32-bit on all platforms. For more
information about running 32-bit Snap-ins in a 64-bit Windows
environment, see:
https://msdn2.microsoft.com/en-us/library/aa815172.aspx
* Event tracing and monitoring information of OpenAccess SDK Service
are reported in ASCII-7 bit. Characters that cannot be transliterated
are replaced by the replacement character '?'
* OpenAccess SDK Management Command Line Using SSL: oacla with command
line options cannot use SSL. Instead, execute oacla in a shell and use
the option asrc to connect to the OpenAccess SDK Server over an SSL
connection. You can also place the asrc and other commands in a file
and specify that file name on the oacla command line.
13. Migrating From OpenAccess SDK 8.1 to OpenAccess SDK 9.0.
For details on upgrading from OpenAcess SDK 8.1 to 9.0, refer to the
Upgrade Notes document at:
https://documentation.progress.com/output/DataDirect/collateral/upgrade.pdf
14. OpenAccess SDK Documentation
The HTML help system is no longer included in the product package. The full
documentation set is now available on the Progress Information Hub:
https://docs.progress.com/category/datadirect-openaccess-sdk. While the product
package will not include the HTML help, the installation Help directory will
provide an HTML redirect for direct access to the documentation.
15. Contacting Progress DataDirect Technical Support
Before calling Progress DataDirect Technical Support (SupportLink), please
collect basic information about your system to help us understand the
environment in which you are working and the exact steps we need to
perform to reproduce the problem. You can contact SupportLink
electronically, by FAX, or by phone.
Our web site at https://www.progress.com/support
connects you to our online support site. Our Web site also gives you
access to DataDirect product information and downloads.
-------------------------------------------------------------------------
End of README