Powered by Zoomin Software. For more details please contactZoomin

DataDirect ODBC ReadMe

Snowflake ODBC 8.0.1 Windows

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

     README
     Progress(R) DataDirect(R)
     Progress(R) DataDirect(R) for ODBC for Snowflake(TM)

     Windows Platforms (32 and 64-bit) 

     8.0.1 Release
     February 2026


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


CONTENTS

Post-GA Product Announcements
Requirements
Installation Directory
Data Source and Platform Support 
Changes for 8.0.1
Release 8.0.0 Features  
Notes, Known Problems, and Restrictions
Driver Workaround Options
Documentation
Installed Files for 32-bit Drivers
Installed Files for 64-bit Drivers


   Post-GA Product Announcements

The readme files will no longer be updated with product announcements and new 
features after the General Availability (GA) of the product. For the latest 
updates and enhancements, please refer to the release notes 
(https://www.progress.com/datadirect-connectors/whats-new).


    Requirements

* The installer program requires a Java Virtual Machine (JVM) that is
  Java SE 11 or higher, including Oracle JDK, OpenJDK, and IBM SDK (Java) 
  distributions.
        
* The driver requires a JVM that is Java SE 8 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


    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  


    Changes for 8.0.1

CVE-2022-41853 - Use of Externally-Controlled Input to Select Classes or Code 
('Unsafe Reflection')
-----------------------------------------------------------------------------
Several Progress DataDirect ODBC drivers utilized a version of HyperSQL 
Database that was vulnerable to remote code execution described in 
CVE-2022-41853.  All impacted drivers have been patched to fix this 
vulnerability.  For details on impacted drivers and fixed versions, refer to 
the following KB article: 
https://community.progress.com/s/article/DataDirect-ODBC-Critical-Security-
Bulletin-November-2022-CVE-2022-41853

Documentation
-------------
Any product package made available after February 9, 2021 will not include the
HTML help system or user's guide PDF. The full documentation set, including
these items, is available from the Progress Information Hub:
https://docs.progress.com/category/datadirect-snowflake

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.

Note that all Progress DataDirect for ODBC documentation has been migrated to
the Progress Information Hub:
https://docs.progress.com/

Enhancements
------------
* The driver has been enhanced to support key-pair authentication. When
  key-pair authentication is enabled (AuthenticationMethod=21), you
  can authenticate to Snowflake using a pair of private and public keys. To
  configure the driver to use key-pair authentication, you can use the new
  Private Key Content (PrivateKeyContent), Private Key File (PrivateKeyFile),
  and Private Key Passphrase (PrivateKeyPassphrase) connection options.
  
* The driver has been enhanced to support the authorization code grant, the
  client credentials grant, and the refresh token grant, in addition to the
  access token flow. Also, on Windows, the Snowflake Configuration Manager may
  now be used to obtain access tokens.

* On Windows, the driver now includes the Snowflake Configuration Manager
  for quick configuration and testing of your driver in a web browser. This
  tool allows you to:
  - Configure data sources and connection strings
  - Test connectivity for your data sources and connection strings
  - Obtain access tokens for OAuth 2.0 authentication
  - Execute SQL commands for testing purposes

* The driver has been modified to map Snowflake data types for fixed-point
  numbers to the Numeric data type by default. In addition, the
  IntegerFieldMapping connection option has been added to the driver. This
  connection option allows you to specify whether fixed-point numbers are
  mapped to Numeric or BigInt.

* 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 now allows you to specify whether the driver fetches metadata 
  for only tables in the database to which you are connected when a database 
  name is not specified in metadata calls. When enabled, this behavior can 
  provide better performance for metadata calls by reducing the number of 
  tables queried. You can use the new Use Session Database For Metadata 
  (UseSessionDatabaseForMetadata) connection option to configure the driver's 
  behavior. Refer to the user's guide for details.

* The driver has been enhanced to support connecting to Snowflake partner 
  applications. You can use the new Partner Application Name 
  (PartnerApplicationName) connection option to specify the name of the 
  partner application to which you want to connect. Refer to the user's
  guide for details.

* 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 the 32-bit driver: From ivicu28.dll to ivicu.dll
  - For the 64-bit driver: From ddicu28.dll to ddicu.dll

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

* The driver has been enhanced to fall back to JSON query format when the arrow
  format is not properly initialized. The driver uses a high-speed arrow 
  transfer that requires the restricted APIs from java.nio package. When the 
  JVM is not correctly configured for Java SE 16 and higher, an exception is 
  returned when the driver executes a query. To allow you to continue executing
  queries in this scenario, you can configure the new Arrow Fallback To JSON 
  (ArrowFallbackToJson) option to switch to the JSON query format.

  Note: This option is not currently exposed on the GUI. To configure the
  option via the GUI, specify the attribute and setting in the Extend Options
  field on the Advanced tab. 

  Feature details: 
  * Available: Driver version 08.00.0100 (B1193, U0945, J001002)

* The drivers using base version B0649 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.

* The driver is enhanced to support the COPY command for loading and unloading 
  data from local file systems and cloud storage platforms.

Changed Behavior
----------------
* 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.
  - To install the 32-bit drivers on 64-bit Windows platforms and start the SQL 
    engine service, the installer requires the 32-bit version of Java SE 11 or 
    higher installed on your machine and defined on your path.


* The installer program has been updated to no longer install common components 
  for drivers that do not use them. As a result, the installer program no longer 
  installs the following common components for the Snowflake driver: 

  - OpenSSL library files, such as ivopenssl30.dll, ddopenssl30.dll, fips.dll, 
    and openssl.cnf.
  - Curl library files, such as ivcurl28.dll and ddcurl28.dll. 

  If the files are not used by any other DataDirect driver on your machine, you 
  can safely remove them from existing product directories.  
   

    Release 8.0.0 Features  

The Progress DataDirect for ODBC for Snowflake provides enhanced 
performance over the native ODBC Snowflake driver. It supports create, 
read, update, and delete operations. In addition, the driver:

* Serves as a complete pass-through driver, leveraging the SQL engine 
  functionality of Snowflake to execute SQL queries.
  
* Supports integration with third-party applications: Tableau, Crystal Reports, 
  Microsoft Excel, Microsoft Access, Microsoft SQL Linked Server, 
  SQL Server Integration Services, and Microsoft Power BI.
  
* Provides proxy support using ProxyHost, ProxyPassword, ProxyPort, and 
  ProxyUser connection options.

* Supports the handling of large result sets with configurable paging using the 
  FetchSize connection option.

* The driver supports authentication methods, such as, OAuth and 
  browser-based single sign-on (SSO).
  
 
    Notes, Known Problems, and Restrictions 

The following are notes, known problems, and restrictions with the latest release
of the driver:

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

* The driver does not support plain text inserts in columns of binary data. 
  Data inserted into columns containing binary data, requires a conversion 
  to hex format.

* The driver does not support scrollable cursor operations on result set data.

* The driver supports Windows 32 and 64-bit, Linux 32 and 64-bit platforms.

* The driver gives a warning message when a SELECT query is run for the first  
  time in a new connection instance, using a console application and OpenJDK 11.

* The OAuth token is valid for 10 minutes, if no connection instance is 
  established or after a connection instance is terminated. A token does not 
  expire in an uninterrupted connection instance.

* For browser-based single sign-on connections, a message appears on the 
  browser "Your identity was confirmed and propagated to Snowflake JDBC driver. 
  You can close this window now and go back where you started from." 
  This is due to the underlying jdbc layer architecture of the driver.

* The active connections viewed on the Snowflake console are termed as JDBC 
  connections. This is due to the underlying JDBC layer architecture of the 
  driver.

* The browser-based SSO authentication does not work in SQL engine server 
  mode when Snowflake server runs as a Windows service. 
   
   
    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 FOR ODBC FOR SNOWFLAKE DOCUMENTATION SET
------------------------------------------------------------------------
The driver documentation set is available from the Progress Information Hub:

https://docs.progress.com/category/datadirect-snowflake

You can access the online help system directly via the HTML redirect in the
installation Help directory.

  
    Installed Files 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 32-bit drivers 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:
---------
ivicu.dll                         Unicode conversion tables
ivicu.pdb                         Debugging symbols for ICU library
IVODBC.LIC                        DataDirect License File
ivsnowflake28.dll                 DataDirect Driver for Snowflake
ivsnowflake28.pdb                 Debugging symbols for DataDirect Driver
ivsnowflake28r.dll                DataDirect Driver for Snowflake resource file                                       
ivtrc28.dll                       DataDirect trace library
ivtrc28.pdb                       Debugging symbols for DataDirect trace library
qesqlext.h                        Header file for DataDirect-specific ODBC 
                                  definitions

\FIXES:
-------
fixes.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  
                    
\java\lib\:
-----------
snowflake.jar                     Java components for the driver

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

\READMES\:
----------
ODBC for Snowflake 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 Snowflake 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
                                  Snowflake 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 
                                  Snowflake 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
snowflakeserver32.exe             The Snowflake SQL Server Engine
XMLP.exe                          A GUI demo tool that persists a result set to
                                  an XML data file                        

\tools\Tableau\:
----------------
DataDirect Snowflake.tdc          Example Tableau data source file                                 
		
\uninstall\:
------------
*.*                               Files used to uninstall the product                             


   Installed Files the 64-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:

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\:
----------
ddsnowflake28.dll                 DataDirect Driver for Snowflake
ddsnowflake28.pdb                 Debugging symbols for DataDirect Driver
ddsnowflake28r.dll                DataDirect Driver for Snowflake resource file                                                                                                       
ddicu.dll                         Unicode conversion tables
ddicu.pdb                         Debugging symbols for ICU library
DDODBC.LIC                        DataDirect License File
ddtrc28.dll                       DataDirect trace library
ddtrc28.pdb                       Debugging symbols for DataDirect trace library
qesqlext.h                        Header file for DataDirect-specific ODBC 
                                  definitions

\FIXES:
-------
fixes.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	
    
                    
\java\lib\:
-----------
snowflake.jar                     Java components for the driver

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

\READMES\:
----------
ODBC for Snowflake 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 Snowflake 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
                                  Snowflake 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 
                                  Snowflake 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
snowflakeserver64.exe              The Snowflake SQL Server Engine 
XMLP.exe                           A GUI demo tool that persists a result set to 
                                   an XML data file   

\tools\Tableau\:
----------------
DataDirect Snowflake.tdc           Example Tableau data source file            
                                
\uninstall\:
------------
*.*                                Files used to uninstall the product     


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