Back

Amazon Web Services, Inc.
Patches for Amazon Redshift ODBC Driver v2 x64
Windows
14 patches available
The Amazon Redshift ODBC Driver is a powerful tool that allows you to connect with live Amazon Redshift data, directly from any applications that support ODBC connectivity. Read, write, and update Amazon Redshift data through a standard ODBC Driver interface.
Amazon Redshift ODBC Driver v2 x64 Version 2.1.8.0
Release Date
7/1/2025
Bug Fix?
Yes
Minor Release?
Yes
Patch Notes

Changelog$$$v2.1.8 (2025-07-01)$$$Added support to change the connection to read-write using mode SQL_ATTR_ACCESS_MODE after the connection was established.$$$Fixed the return data type for Date/Time columns in SQLColumns API to match the configured ODBC version set via SQL_ATTR_ODBC_VERSION.$$$Fixed incorrect streaming cursor state handling after SQLTables API catalog list retrieval.$$$Fixed an issue where the driver incorrectly treated NULL parameters as empty strings in SQLTables when using SQL_ALL_CATALOGS; which caused it to return a catalog list instead of the expected table list.$$$Removed legacy code containing unused libpq quoting functions.$$$Resolved build issues when compiling the Windows driver from GitHub source code.$$$Added support for all Glue Data type in the SQLColumns metadata API; enabling accurate column type information retrieval from AWS Glue catalogs.$$$Enhanced the ODBC drivers data retrieval functionality by implementing proper offset tracking and buffer management through SQLGetData API to correctly handle large data sets retrieved in chunks; ensuring sequential data access rather than repeated retrieval of initial data segments.$$$Fixed a memory leak issue that occurred when initializing result set fields in SQLTables and SQLColumns API calls.$$$$$$$$$
Amazon Redshift ODBC Driver v2 x64 Version 2.1.7.0
Release Date
3/6/2025
Bug Fix?
Yes
Minor Release?
Yes
Patch Notes

Changelog$$$v2.1.7 (2025-03-06)$$$Fixed an issue with batch insertion parameters where SQL_ATTR_PARAMSET_SIZE updates were not being properly applied between SQLPrepare and SQLExecute calls.$$$Updated to latest OpenSSL 1.1.1.$$$Fixed SQLTables metadata API to properly include external schemas when listing all schemas in the current database.$$$Corrected SQLTables metadata API result ordering to properly sort by catalog name.$$$Added support for serverless cluster authentication via GetClusterCredentials API - connect to workgroups by prefixing “redshift-serverless” to ClusterId field (server field optional).$$$Added support for network load balancer (NLB) hostnames in server name fields.
Amazon Redshift ODBC Driver v2 x64 Version 2.1.7.0
Release Date
3/6/2025
Bug Fix?
Yes
Minor Release?
Yes
Patch Notes

Changelog$$$v2.1.7 (2025-03-06)$$$Fixed an issue with batch insertion parameters where SQL_ATTR_PARAMSET_SIZE updates were not being properly applied between SQLPrepare and SQLExecute calls.$$$Updated to latest OpenSSL 1.1.1.$$$Fixed SQLTables metadata API to properly include external schemas when listing all schemas in the current database.$$$Corrected SQLTables metadata API result ordering to properly sort by catalog name.$$$Added support for serverless cluster authentication via GetClusterCredentials API - connect to workgroups by prefixing “redshift-serverless” to ClusterId field (server field optional).$$$Added support for network load balancer (NLB) hostnames in server name fields.
Amazon Redshift ODBC Driver v2 x64 Version 2.1.6.0
Release Date
12/23/2024
Bug Fix?
Yes
Minor Release?
Yes
Patch Notes

v2.1.6 (2024-12-23)$$$Introduced token caching support for Browser IdC Auth plugin.$$$Updated the logic for retrieving database metadata through the SQLTables() and SQLColumns() API methods.$$$Addressed security issues as detailed in CVE-2024-12746$$$Fixed an issue where data types returned for the BUFFER_LENGTH; DECIMAL_DIGITS; NUM_PREC_RADIX; and NULLABLE columns= in the SQLColumns ODBC API call result set for external schema did not conform to the ODBC specification.$$$Increased buffer size of MAX_IDEN_LEN to support connection parameter inputs up to 1024 characters.$$$Improved build system; removed prebuilt dependencies and introduced an automated script to build driver dependencies from source.
Amazon Redshift ODBC Driver v2 x64 Version 2.1.4.0
Release Date
11/12/2024
Bug Fix?
Yes
Minor Release?
Yes
Patch Notes

v2.1.4 (2024-11-12)$$$Increased the session token buffer size from 1024 bytes to 2048 bytes to accommodate larger V2 tokens during IAM authentication processes.$$$Improved regex processing of user provided URIs in all IAM authentication workflows.$$$Improved String Manipulation Functions: stristr (Case-Insensitive String Search); strcasewhole (Whole Word Case-Insensitive Comparison); strcasestr (Custom Case-Insensitive Substring Search for windows); and findSQLClause (SQL Clause Extraction).$$$Fixed Unicode Handling in getParamVal for Prepared Query Processing.$$$Updated the version of aws-sdk-cpp to 1.11.336 (windows).$$$Implemented mandatory default functionality for aws-sdk-cpps WinSyncHttpClient::DoQueryDataAvailable and WinSyncHttpClient::GetActualHttpVersionUsed methods; ensuring compliance with the AWS SDK.$$$Upgraded the c-ares library dependency for Windows to version 1.29.0$$$Upgraded the googletest library dependency for Windows to version 1.14.0$$$Updated the cmake_minimum_required version from 3.12 to 3.20$$$Migrated the Windows build process to utilize the CMake build system. To build and package for Windows; execute the build64.bat script located in the projects root directory.$$$Added support for building ODBC2.x Windows driver in both Release and Debug modes; ensuring that the required dependencies are available in their respective Debug and Release subfolders; enabling more comprehensive testing and debugging scenarios.$$$Enhanced the build scripts by removing unused build and test files; and implemented a consistent naming convention by prefixing internal CMake variables with RS_ for better organization and maintainability.$$$Removed the use of the -MMD; -MP; and -MF compiler options in the CMake build configuration for Linux; resolving compatibility issues with C++17 std::string_view.$$$Fixed an issue where the data types returned for the BUFFER_LENGTH; DECIMAL_DIGITS; NUM_PREC_RADIX; and NULLABLE columns in the result set of the SQLColumns ODBC API call were not conforming to the ODBC specification.$$$Updated the SQL data type representations in the rscatalog component for date; time; timetz; time with time zone; timestamp without time zone; timestamptz; and timestamp to use the non-concise data type instead of the concise data type.$$$Added support to connect to Redshift via managed Virtual Private Cloud (VPC) endpoints.
Amazon Redshift ODBC Driver v2 x64 Version 2.1.3.0
Release Date
7/31/2024
Bug Fix?
Yes
Minor Release?
Yes
Patch Notes

v2.1.3 (2024-07-31)$$$Fixed an inconsistent metadata issue for Redshift type timestamptz in SQLColumns and SQLDescribeCol by changing the return value for Data type column in SQLColumns API from 2014 to SQL_TYPE_TIMESTAMP (93) and in SQLDescribeCol API from SQL_VARCHAR (12) to SQL_TYPE_TIMESTAMP (93).$$$Fixed an issue when invoking SQLBindParameter with the C type SQL_C_DEFAULT by converting SQL_C_DEFAULT to a new C type based on the SQL type. Also; added enhanced logging to provide informational and error messages related to SQL_C_DEFAULT conversions.$$$Added missing group federation checkbox in JWT IAM Auth Plugin ODBC DSN GUI in Windows.$$$Fixed an issue where an incorrect return value was generated when calling SQLGetData with the C type SQL_C_DEFAULT.$$$Added support for a new browser authentication plugin called BrowserIdcAuthPlugin to facilitate single-sign-on integration with AWS IAM Identity Center.
Amazon Redshift ODBC Driver v2 x64 Version 2.1.2.0
Release Date
6/6/2024
Bug Fix?
Yes
Minor Release?
Yes
Patch Notes

v2.1.2 Latest$$$Upgraded the deprecated minimum TLS functions in OpenSSL to more versatile TLS methods that can support multiple TLS protocol versions.$$$Updated the default minimum TLS version to the more secure and faster TLS 1.2; changed from the previous default of TLS 1.0.$$$Added new options in the Windows ODBC DSN GUI to allow setting the minimum TLS version to any supported version.$$$Fixed a bug where the user option to provide the database username in the connection string was not working when connecting to Redshift using a database username and password.$$$Fixed an issue with querying large geometry data type using SQLGetData.$$$Fixed an issue in SQLFetch function where query buffer offset was not being reset properly; causing function execution to hang.$$$Fixed issues in unicode conversion utility methods used internally. Updated calls to these conversion methods in the SQLForeignKeysW; SQLPrimaryKeysW; SQLColumnsW and SQLDriverConnectW APIs.$$$Added missing OID mapping for Redshift Text data type.$$$Added missing invalid SQL type validation in SQLBindParameter API.$$$Fixed bug where databaseMetadataCurrentDbOnly flag was not using its default value when it is not included in DSN in Linux.$$$Updated catalog filter to use LIKE instead of = to allow filter patterns with % in catalog name in ODBC metadata APIs like SQLTables.$$$Fixed a bug where datatype of DECIMAL_DIGITS; NUM_PREC_RADIX; and NULLABLE columns in SQLColumns API result set were not following ODBC specification. This can impact behavior on some clients and tools.
Amazon Redshift ODBC Driver v2 x64 Version 2.1.0.0
Release Date
2/28/2024
Bug Fix?
Yes
Minor Release?
Yes
Patch Notes

v2.1.0.0 (2024-02-28)$$$Added support for LZ4 and ZSTD compression over wire protocol communication between Redshift server and the client/driver. Compression is turned off by default and can be set using a new connection parameter compression=off or lz4 or zstd.$$$Added support for unit-testing using Google Test framework.$$$Upgrade unixODBC dependency from v2.3.1 to v2.3.7 (Linux release).$$$Fix handling of null termination during unicode processing in SQLDescribeColW API.
Amazon Redshift ODBC Driver v2 x64 Version 2.0.1.0
Release Date
1/25/2024
Bug Fix?
Yes
Minor Release?
Yes
Patch Notes

v2.0.1.0 (2024-01-25)$$$Added support for Serverless Custom Name. Upgraded windows aws-sdk-cpp to 1.11.218 accordingly.$$$Added support for interval data types: SQL_INTERVAL_YEAR_TO_MONTH and SQL_INTERVAL_DAY_TO_SECOND. They can be retrieved as text or using the C structures SQL_YEAR_MONTH_STRUCT and SQL_DAY_SECOND_STRUCT.$$$Migrated Linux to cmake build system.$$$Build base libraries statically into librsodbc64.so including libgcc and libstdc++.$$$Fixed CaFile and CaPath connection options and default root certificate name for IAM and non-IAM connections.$$$Fixed support for group_federation connection parameter that allows customers to use getClusterCredentialsWithIAM in provisioned clusters.$$$Refactor and extend Logging system to accept options from connection string.$$$Removed ssooidc dependencies from build system.
Amazon Redshift ODBC Driver v2 x64 Version 2.0.0.11
Release Date
11/21/2023
Bug Fix?
Yes
Minor Release?
Yes
Patch Notes

v2.0.0.11 (2023-11-21)$$$Upgraded openssl (v1.1.1w) and removed redundant libcURL build dependencies for Windows.$$$Removed outdated Linux build dependencies.$$$Added ability to connect to datashare databases for clusters and serverless workgroups running the PREVIEW_2023 track$$$Removed BrowserIdcAuthPlugin.
Amazon Redshift ODBC Driver v2 x64 Version 2.0.0.9
Release Date
9/11/2023
Bug Fix?
Yes
Minor Release?
Yes
Patch Notes

v2.0.0.9 (2023-09-11)$$$Added Identity Center authentication support with new plugins.$$$Fixed IAM Authentication to support longer temporary passwords from 129 to 32767 characters.$$$Added automatic region detection for Custom Cluster Naming (CNAME) feature.
Amazon Redshift ODBC Driver v2 x64 Version 2.0.0.8
Release Date
8/15/2023
Bug Fix?
Yes
Minor Release?
Yes
Patch Notes

Changelog$$$v2.0.0.8 (2023-08-15)$$$Fixed regular expressions used for parsing HTML Tag value responses received form for Ping IdP.[Ruei-Yang Huang]$$$Added a new JWT IAM authentication plugin (JwtIamAuthPlugin) to replace BasicJwtCredentialsProvider which has been repurposed to support the new nativeIdP authentication.[Naveen Kumar]$$$Revert a memory issue fix in libpq’s MesageLoopState that was resulting in crashes since v2.0.0.6.[Vahid Saber Hamishagi]$$$Fixed enablement settings for Custom-Cluster Naming (CNAME) for Windows platform which was disabling CNAME permanently.[Janak Khadka]
Amazon Redshift ODBC Driver v2 x64 Version 2.0.0.6
Release Date
5/23/2023
Bug Fix?
Yes
Minor Release?
Yes
Patch Notes

v2.0.0.6 (2023-05-23)$$$Fix memory leak detected in API tests and conformance tests. [Ruei-Yang Huang]$$$Add test to verify the correctness of the character_octect_length column retrieved from SQLColumns function [Janak Khadka]$$$Support query column result larger than 2048 characters. [Vahid Saber Hamishagi]
Amazon Redshift ODBC Driver v2 x64 Version 2.0.0.5
Release Date
3/28/2023
Bug Fix?
Yes
Minor Release?
Yes
Patch Notes

Minor codestyle changes. [Vahid Saber Hamishagi]$$$Fix Driver insert NULL into geometry column instead of returning error. [Janak Khadka]$$$Fix large column size issue in SQL_C_WCHAR->SQL_VARCHAR conversion. [Vahid Saber Hamishagi]$$$Fix user AutoCreate feature in IAM. [Janak Khadka]
Amazon Redshift ODBC Driver v2 x64 Version 2.0.0.3
Release Date
2/10/2023
Bug Fix?
Yes
Minor Release?
Yes
Patch Notes

v2.0.0.3 (2023-02-10)$$$Unicode Conversion Fix. [Vahid Saber Hamishagi]$$$Improve parsing Connection String containing special characters. [Vahid Saber Hamishagi]$$$IAM imporovements. [Vahid Saber Hamishagi]$$$Fixes in plugin Identity Provider: PingFederate. [Vahid Saber Hamishagi]$$$Replace auto_ptr with unique_ptr in IAM. [Vahid Saber Hamishagi]$$$ARN Fix. [Vahid Saber Hamishagi]$$$Upgrade Linux build to C++17. [Vahid Saber Hamishagi]$$$Upgrade windows build. [Vahid Saber Hamishagi]$$$Upgrade to ssl 1.1.1. [Vahid Saber Hamishagi]$$$Upgrade to aws-cpp-sdk v1.9.289. [Vahid Saber Hamishagi]$$$Tracking large files(*.lib files) [Vahid Saber Hamishagi]
Interested in automating patching for Amazon Redshift ODBC Driver v2 x64?