Symptom:
This issue is specific to using the Amazon Redshift ODBC Driver version 1.4.4.1001 on Strategy 2019 and earlier for Linux operating systems. Upon completing the instructions for installing and configuring the driver, an error message is thrown when testing the DSN in ODBC Test Tool.
Error Message:
Connect failed. Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. [IM003:0: on HDBC] [DataDirect][ODBC lib] Specified driver could not be loaded
Cause:
When testing the loading process of the driver, 'GLIBCXX_3.4.20' could not be found and is required. This version is a newer version compared to what is shipped currently by the Strategy Product Suite.
Action/Workaround:
Instead of utilizing Amazon Redshift ODBC Driver version 1.4.4.1001, install and configure Amazon Redshift ODBC Driver version 1.4.3.1000. This driver has been confirmed to not incur this issue.
KB482930