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

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.

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.

Workstation to streamline your accounts; apps; and workflows

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.

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 Data Connector$$$1.5.20$$$Released October 2024$$$These release notes provide details of enhancements; features; known issues; and$$$workflow changes in Amazon Redshift ODBC Connector 1.5.20; as well as the version$$$history.$$$Enhancements & New Features$$$Updated third-party libraries$$$The connector now uses the following third-party libraries:$$$• Expat 2.6.3 (previously 2.6.2)$$$• LibCurl 8.10.1 (previously 8.7.1)$$$• OpenSSL 3.0.15 (previously 3.0.13)$$$Group Federation Support in JwtIamAuthPlugin$$$The connector now supports Group Federation in JwtIamAuthPlugin. For more$$$information; see the Installation and Configuration Guide.$$$Workflow Changes$$$The following changes may disrupt established workflows for the connector.

Amazon Redshift ODBC Data Connector$$$1.5.16$$$Released July 2024$$$These release notes provide details of enhancements; features; known issues; and$$$workflow changes in Amazon Redshift ODBC Connector 1.5.16; as well as the version$$$history.$$$Enhancements & New Features$$$Updated Ubuntu version support$$$The connector now supports Ubuntu 24.04. For supported versions; see the$$$Installation and Configuration Guide.$$$Updated third-party libraries$$$The connector now uses the following third-party libraries:$$$• Expat 2.6.2 (previously 2.6.0)$$$• LibCurl 8.7.1 (previously 8.6.0)$$$Updated AWS SDK support$$$On Windows; the HTTP client in AWS SDK is now libcurl. Previously; it was$$$WinHTTP.$$$Resolved Issues$$$The following issues have been resolved in Amazon Redshift ODBC Connector 1.5.16.$$$• On Windows; when authenticating with AWS IAM Credentials; the connector$$$returns a Encountered network error when sending http request error message.$$$• When the enable_case_sensitive_identifier server configuration is enabled;$$$SQLTables() returns an error.$$$• When using ADFS with WIA; the connector returns a Conversion from string to$$$number failed with value error message.$$$Amazon Redshift ODBC Connector 1.5.16 Release Notes$$$2$$$Known Issues$$$The following are known issues that you may encounter due to limitations in the data$$$source; the connector; or an application.$$$• Limited support for stored procedures.$$$The connector does not support parameterized procedure call queries if there is$$$more than one procedure of different argument types that share the same name$$$in the server.$$$• Timestamps do not accept negative values.$$$The connector does not support the use of negative values in timestamps.$$$Workflow Changes$$$The following changes may disrupt established workflows for the connector

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.

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.

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.

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.

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.

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 Data Connector$$$1.5.7$$$Released September 2023$$$These release notes provide details of enhancements; features; known issues; and$$$workflow changes in Amazon Redshift ODBC Connector 1.5.7; as well as the version$$$history.$$$Enhancements & New Features$$$Updated endpoint support$$$You can now override the Amazon Redshift endpoint when using IAM$$$authentication. To do this; in the VPC Endpoint URL field specify the endpoint$$$URL (set the VpcEndpointUrl property). For more information; see the$$$Installation and Configuration Guide.$$$Updated third-party libraries$$$The connector has been updated to use the following libraries:$$$• AWS SDK 1.9.362 (previously 1.9.136)$$$• Expat 2.5.0 (previously 2.4.6)$$$• ICU 71.1.x (previously 58.3.x)$$$• libcurl 8.1.2 (previously 7.78.0)$$$• OpenSSL 3.0.9 (previously 1.1.1q)$$$• Zlib 1.2.13 (previously 1.2.11)$$$For OpenSSL; the certificates used for identity providers might need to be$$$regenerated since some encryption algorithms have been deprecated in$$$OpenSSL 3.$$$Updated platform support$$$The connector now supports the following versions:$$$• Debian 10 and 11$$$Amazon Redshift ODBC Connector 1.5.7 Release Notes$$$2$$$• Ubuntu 22.04$$$• Windows 11$$$• Windows Server 2022$$$For more information; see the Installation and Configuration Guide.$$$Resolved Issues$$$The following issues have been resolved in Amazon Redshift ODBC Connector 1.5.7.$$$• In some cases; when calling SQLColumns; the connector returns a invalid input$$$syntax for integer: error message.$$$• When calling SQLColumns for datasharing external tables; the connector returns$$$incorrect values for the NULLABLE and IS_NULLABLE columns.$$$• When calling SQLColumns; the connector returns different metadata between$$$local and external tables.$$$Known Issues$$$The following are known issues that you may encounter due to limitations in the data$$$source; the connector; or an application.$$$• Connector overrides custom SQLState for ODBC 2.x$$$In some errors/warnings scenario; custom SQLState (i.e. SQLState 42P01) is$$$overridden to SQLState S1000 for errors and 01000 for warnings. This affects$$$1.5.x releases up to 1.5.7.$$$• Limited support for stored procedures.$$$The connector does not support parameterized procedure call queries if there is$$$more than one procedure of different argument types that share the same name$$$in the server.$$$• Timestamps do not accept negative values.$$$The connector does not support the use of negative values in timestamps.$$$Workflow Changes$$$The following changes may disrupt established workflows for the connector.$$$Amazon Redshift ODBC Connector 1.5.7 Release Notes$$$3$$$Version 1.5.7$$$Removed support for Windows 8.1$$$Beginning with this release; the connector no longer supports Windows 8.1. For a list of$$$supported Windows versions; see the Installation and Configuration Guide

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]

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]

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]

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]

Amazon Redshift ODBC Data Connector$$$1.4.65$$$Released January 2023$$$These release notes provide details of enhancements; features; known issues; and $$$workflow changes in Amazon Redshift ODBC Connector 1.4.65; as well as the version $$$history.$$$Enhancements & New Features$$$Updated Platform support$$$The connector now supports the following Windows version:$$$• Windows 11$$$• Windows Server 2022$$$For more information; see the Installation and Configuration Guide.$$$Resolved Issues$$$The following issues have been resolved in Amazon Redshift ODBC Connector 1.4.65.$$$• When using PingFederate authentication; the connector does not support $$$SimultaneousAuthnRequestCheckingFilter on PingFederate 11.1 and $$$later versions. $$$• On calling the SQLDriverConnect() function leads to a memory leak in the $$$connector.$$$Known Issues$$$The following are known issues that you may encounter due to limitations in the data $$$source; the connector; or an applicat

Released October 2022$$$These release notes provide details of enhancements; features; known issues; and $$$workflow changes in Amazon Redshift ODBC Connector 1.4.59; as well as the version $$$history.$$$Enhancements & New Features$$$Azure AD OAuth2 authentication support$$$You can now use Azure AD OAuth2 to authenticate your connections. For more $$$information; see the Installation and Configuration Guide.$$$Updated third-party libraries$$$The connector has been updated to use the following libraries:$$$• libcurl 7.78.0 (previously 7.84.0)$$$• OpenSSL 1.1.1q (previously 1.1.1n)$$$Resolved Issues$$$The following issues have been resolved in Amazon Redshift ODBC Connector 1.4.59.$$$• When SingleRowMode is enabled and two queries are executed in a row; the$$$connector returns a Query cancelled on users request error for the latter query.$$$• When authenticating with AWS Profile and the equal sign ( = ) appears in$$$credential_process; th

These release notes provide details of enhancements; features; known issues; and$$$workflow changes in Amazon Redshift ODBC Connector 1.4.56; as well as the version$$$history.$$$Enhancements & New Features$$$Group federation support$$$You can now configure the connector to use group federation when using AWS$$$IAM Credentials or AWS Profile for authentication. To do this; select the Group$$$Federation checkbox (set the group_federation property to 1). For more$$$information; see the Installation and Configuration Guide.$$$Application name support$$$You can now set the name of the current application on the server. To do this; set$$$the ApplicationName property to application name. For more information; see$$$the Installation and Configuration Guide.$$$Updated AWS SDK and endpoint support$$$The connector has been updated to use version 1.9.289 of AWS SDK and now$$$supports workgroups in serverless endpoints. Previously; the connector used$$$1.9.136.$$$Updated SSL support$$$You can now retrieve the SSL information of a connection using the$$$PGO_CONN_SSL_INFO custom attribute with SQLGetConnectAttr. The value of$$$PGO_CONN_SSL_INFO is 16385.$$$Resolved Issues$$$The following issue has been resolved in Amazon Redshift ODBC Connector 1.4.56.$$$ When terminating the connection from the server using Declare or Fetch mode;$$$the connector terminates unexpectedly.$$$Amazon Redshift ODBC Connector 1.4.56 Release Notes$$$2$$$Known Issues$$$The following are known issues that you may encounter due to limitations in the data$$$source; the connector; or an application.$$$ Limited support for stored procedures.$$$The connector does not support parameterized procedure call queries if there is$$$more than one procedure of different argument types that share the same name$$$in the server.$$$ Timestamps do not accept negative values.$$$The connector does not support the use of negative values in timestamps.