Powered by Zoomin Software. For more details please contactZoomin

DataDirect ODBC ReadMe

SAP ASE ODBC 8.0.2 Windows

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

     README
     Progress(R) DataDirect(R)
     Progress DataDirect for ODBC for SAP ASE Wire Protocol Driver 

     Windows Platforms (32- and 64-bit)
     Release 8.0.2
     April 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 SAP ASE(TM) Wire Protocol Driver. 

This README file contains information not included in the PROGRESS 
DATADIRECT FOR ODBC FOR SAP ASE WIRE PROTOCOL DRIVER USER'S GUIDE.



CONTENTS

Post-GA Product Announcements
Requirements
Installation Directory 
Data Source and Platform Support
Third-party Components Compatibility Matrix 
Changes for 8.0.2 GA
Driver WorkAround Options
Notes, Known Problems, and Restrictions
Documentation
Installed Files for the 32-bit Driver
Installed Files for the 64-bit Driver 


   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 library:
  Microsoft Visual C/C++ runtime version 14.40.33810 or higher

* IMPORTANT: You must have the Microsoft Data Access Components (MDAC) 
  installed to use this product.
 
  - For 32-bit Windows systems, version 2.6 or higher is required.
  - For 64-bit Windows systems, version 2.8 or higher 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.
    
    
        Installation Directory 

* The default installation directory for the 32-bit driver on a 64-bit 
  system is:

  C:\Program Files (x86)\Progress\DataDirect\ODBC

* The default installation directory for all other installations is:

  C:\Program Files\Progress\DataDirect\ODBC


    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 for 8.0.2 GA

Driver Enhancements
-------------------
* The product package now includes .pdb files. These files contain debugging 
  symbols that can be used for diagnosing and debugging issues in the driver.

* The driver is now compiled with a Visual Studio 2022 compiler for Windows 
  platforms. As a result, you must have Microsoft Visual C/C++ runtime 
  version 14.40.33810 or higher on your machine to run the 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   

* The driver has 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. 

Changed Behavior
----------------
* The driver has been updated to return Adaptive Server Enterprise as the 
  DBMS name, instead of SQL Server, for the following:
  - SQLGetInfo calls
  - Error messages

* The TLSv1.1 and TLSv1.0 cryptographic protocols are now disabled by default 
  and have been removed as selectable options for the Crypto Protocol Version
  (CryptoProtocolVersion) option on the Setup dialog. These protocols are no
  longer considered secure and, therefore, are no longer recommended for use.
  However, the driver still supports them for legacy servers that do not 
  support more secure protocols.


    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 Issues, and Restrictions

Real Data Type Limitation
--------------------------
For values of the real data type, to comply with the SAP ASE 
server, the driver ensures the accuracy of the values 
loaded through bulk load only up to 6 digits.

Money Data Type Limitation
--------------------------
For values of the money data type, to comply with the SAP ASE 
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.

No Support for Inserting LOB columns Using Bulk Load Protocol
-------------------------------------------------------------
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.

Bulk Insert Fails When Non-identity Columns are Omitted
-------------------------------------------------------
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.

Limitation of the Test Connect Button (Setup Dialog Box)
--------------------------------------------------------
On the Logon dialog box, there is a Database drop-down list that 
displays the database names specified on the Connection tab of the ODBC 
SAP ASE Wire Protocol Driver Setup dialog box. This functionality is 
available in all cases except when connecting through the Test Connect 
button on the Setup dialog box. When connecting through the Test 
Connect button, only the default database specified on the General tab 
of the Setup dialog box is available.

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.

126 Error When Modifying Data Sources on Windows 10
---------------------------------------------------
You may receive a 126 error when adding or configuring a data source stored
on a network location. This is caused by the settings of the User Account 
Control (UAC) security feature on Windows 10. To work around this issue:

Important: Implementing this fix disables security safeguards that are designed
to protect your machine. Before starting, refer to the following Microsoft 
documentation for potential risks associated with disabling the UAC feature:  
http://windows.microsoft.com/en-us/
windows/what-are-user-account-control-settings

1.  From the Start menu, type regedit in the search field; then, select regedit
    from the results list. The Registry Editor window opens. 

2.  Navigate to the following registry subkey: 

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System

3.  Right-click on the subkey; then, select New > DWORD Value. 

4.  Rename the new value EnableLinkedConnections. 

5.  Right-click EnableLinkedConnections, and then click Modify. The Edit DWORD 
    Value window opens. 

6.  In the Value data field, type 1. Click OK. 

7.  Close the Registry Editor; then, restart your computer. 
  
Upgrading from an Evaluation to a Licensed Installation
-------------------------------------------------------
If you have installed an evaluation copy of the drivers and want to 
upgrade to a licensed version, you must use the Modify option of the 
installation program. 

Installing and Removing Default Data Sources
--------------------------------------------
When you first install a driver, you are given the option to install a 
default data source for that driver. We recommend that you install 
default data sources when you first install the drivers. If you do not 
install the default data source at this time, you will be unable to 
install a default data source for this driver later. To install a 
default data source for a driver after the initial installation, you 
must uninstall the driver and then reinstall it.

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 OpenSSL documentation.
  
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 Developers Using IIS
------------------------
One of the most common connectivity issues encountered while using IIS 
(Microsoft's Internet Information Server) concerns the use and settings 
of the account permissions. If you encounter problems using DataDirect 
drivers with an IIS server, refer to KnowledgeBase document number 4274 
on the Progress DataDirect web site:

http://knowledgebase.datadirect.com.


    Documentation

PROGRESS DATADIRECT FOR ODBC FOR SAP ASE WIRE PROTOCOL DRIVER 
DOCUMENTATION SET
----------------------------------------------------------------
The user's guide is available as an HTML help system on the DataDirect 
documentation web page:

https://docs.progress.com/category/datadirect-sap-sybase

You can also launch the help system by clicking the Help button in the 
Setup dialog box.


     Installed Files for the 32-bit Driver

This file list assumes a full installation of the driver and 
documentation.

The installer copies the following file to the Windows system 
directory:

ivtrc28.dll           DataDirect trace library

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

For the 32-bit driver on 64-bit machines:

  C:\Program Files (x86)\Progress\DataDirect\ODBC

For all other installations:

  C:\Program Files\Progress\DataDirect\ODBC

\<install_dir>\:
----------------  
license.txt                       Progress DataDirect license agreement


\drivers\:
---------
ivase28.dll                       SAP ASE Wire Protocol Driver
ivase28.pdb                       Debugging symbols for SAP ASE Wire 
                                  Protocol Driver
ivase28r.dll                      SAP ASE Wire Protocol Driver
                                  resource file     
ivicu.dll                         Unicode conversion tables
ivicu.pdb                         Debugging symbols for ICU library
IVODBC.LIC                        DataDirect license file
ivopenssl30.dll                   TLS/SSL support file (OpenSSL library 
                                  version 3.0)
ivopenssl30.pdb                   Debugging symbols for OpenSSL 3.0 library
ivopenssl.dll                     TLS/SSL support file (OpenSSL library file,
                                  version 3.5)
ivopenssl.pdb                     Debugging symbols for OpenSSL 3.5 library
ivtrc28.dll                       DataDirect trace library
ivtrc28.pdb                       Debugging symbols for DataDirect trace library  
ivtrn28.dll                       DataDirect sample translation DLL
qesqlext.h                        Header file for DataDirect-specific ODBC 
                                  Definitions               


\FIXES\: 
-------- 
fixes8.0.txt                      List of fixes since last release

                               
\help\:
------
*.html                            HTML redirects to online connector help systems
                                  and documentation resources


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


\NOTICES\:
---------
ODBC for SAP ASE v8.0 
notices.txt                       Third-party vendor license agreements


\READMES\:
---------
ODBC for SAP ASE v8.0 
readme.txt                        This file


\samples\bulk\:
--------------
bulk.c                            Bulk example source
bulk.exe                          Bulk application
bulk.mak                          Bulk example make file
bulk.sln                          Bulk example solution file
bulk.vcproj                       Bulk example project file
ddlogging.properties              Log configuration file for the
                                  SAP ASE driver


\samples\bulkstrm\:
------------------                       
bulk.cpp                          Bulk streaming example source
bulk.hpp                          Bulk streaming example header
bulk.rc                           Bulk streaming example resource file
bulkstreaming.sln                 Bulk streaming example solution file
bulkstreaming.vcproj              Bulk streaming example project file
bulkstrm.exe                      Bulk streaming example application
bulkstrm.txt                      Bulk streaming description
ddlogging.properties              Log configuration file for the
                                  SAP ASE driver
msgprintf.hpp                     Bulk streaming example header file
ProgressDataDirect.bmp
ProgressDataDirect.ico
winmain.cpp                       Bulk streaming example source file


\samples\example\:
-----------------
ddlogging.properties              Log configuration file for the
                                  SAP ASE driver
example.c                         Example source
Example.exe                       Example application
example.h                         Example header
Example.mak                       Example make file
Example.sln                       Example solution file
Example.vcproj                    Example project file


\samples\translat\:
-----------------
LIBMAIN.C                 
README.TRN                        Translation Library example description
TRANSLAT.C                        Translation Library example source file
WINNT.MAK                         Translation Library example make file


\tools\:
-------
ddextwin.exe                      License Extender utility
ddprocinfo.exe                    Processor Information utility
DSNConverterSil.exe               Data Source Converter utility
XMLP.exe                          A GUI demo tool that persists a result set
                                  to an XML data file

\tools\Power BI:
----------------
DataDirectSAPASE.pqx              SAP ASE Power BI connector file
install.bat                       Batch file to install Power BI connectors


\tools\Tableau\:
----------------
DataDirect SAP ASE.tdc            Tableau data source file   

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


    Installed Files for the 64-bit Driver

This file list assumes a full installation of the driver and its
documentation. 

The installer copies the following file to the Windows system 
directory:

ddtrc28.dll           DataDirect trace library

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

   C:\Program Files\Progress\DataDirect\ODBC:   
        
\<install_dir>\:
----------------
license.txt                       Progress DataDirect license agreement

 
\drivers\:
---------
ddase28.dll                       SAP ASE Wire Protocol Driver
ddase28.pdb                       Debugging symbols for SAP ASE Wire 
                                  Protocol Driver
ddase28r.dll                      SAP ASE Wire Protocol Driver 
                                  resource file
ddicu.dll                         Unicode conversion tables
ddicu.pdb                         Debugging symbols for ICU library     
DDODBC.LIC                        DataDirect license file
ddopenssl30.dll                   TLS/SSL support file (OpenSSL library 
                                  version 3.0)
ddopenssl30.pdb                   Debugging symbols for OpenSSL 3.0 library
ddopenssl.dll                     TLS/SSL support file (OpenSSL library file,
                                  version 3.5)
ddopenssl.pdb                     Debugging symbols for OpenSSL 3.5 library
ddtrc28.dll                       DataDirect trace library
ddtrc28.pdb                       Debugging symbols for DataDirect trace library
fips.dll                          Support file for FIPS provider
fips.pdb                          Debugging symbols for FIPS provider
openssl.cnf                       Configuration file for FIPS provider
qesqlext.h                        Header file for DataDirect-specific ODBC 
                                  Definitions


\FIXES\: 
-------- 
fixes8.0.txt                      List of fixes since last release

                                  
\help\:
------
*.html                            HTML redirects to online connector help systems
                                  and documentation resources


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


\NOTICES\:
---------
ODBC for SAP ASE v8.0
notices.txt                       Third-party vendor license agreements


\READMES\:
---------
ODBC for SAP ASE v8.0
readme.txt                        This file


\samples\bulk\:
---------------
bulk.c                            Bulk example source
bulk.exe                          Bulk application
bulk.mak                          Bulk example make file
bulk.sln                          Bulk example solution file
bulk.vcproj                       Bulk example project file
ddlogging.properties              Log configuration file for the
                                  SAP ASE driver
                       

\samples\bulkstrm\:
-------------------
bulk.cpp                          Bulk streaming example source
bulk.hpp                          Bulk streaming example header
bulk.rc                           Bulk streaming example resource file
bulkstreaming.sln                 Bulk streaming example solution file
bulkstreaming.vcproj              Bulk streaming example project file
bulkstrm.exe                      Bulk streaming example application
bulkstrm.txt                      Bulk streaming description
ddlogging.properties              Log configuration file for the
                                  SAP ASE driver
msgprintf.hpp                     Bulk streaming example header file
ProgressDataDirect.bmp
ProgressDataDirect.ico
winmain.cpp                       Bulk streaming example source file


\samples\example\:
------------------
ddlogging.properties              Log configuration file for the
                                  SAP ASE driver
example.c                         Example source
Example.exe                       Example application
example.h                         Example header
Example.mak                       Example make file
Example.sln                       Example solution file
Example.vcproj                    Example project file


\samples\translat\:
-----------------
LIBMAIN.C                 
README.TRN                        Translation Library example description
TRANSLAT.C                        Translation Library example source file
WINNT.MAK                         Translation Library example make file


\tools\:
-------
ddextwin.exe                      License Extender utility
ddprocinfo.exe                    Processor Information utility
DSNConverterSil.exe               Data Source Converter utility
XMLP.exe                          A GUI demo tool that persists a result set to
                                  an XML data file


\tools\Power BI:
----------------
DataDirectSAPASE.pqx              SAP ASE Power BI connector file
install.bat                       Batch file to install Power BI connectors


\tools\Tableau\:
----------------
DataDirect SAP ASE.tdc            Tableau data source file    

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


~~~~~~~~~~~~~~
April 2026
End of README

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