Please first make sure you have looked at:

• Documentation: https://github.com/mkleehammer/pyodbc/wiki
• Other issues

Environment

To diagnose, we usually need to know the following, including version numbers. On Windows, be
sure to specify 32-bit Python or 64-bit:

• Python: 3.7.10
• pyodbc: 4.0.34
• OS: Linux
• DB: Redshift
• driver: /opt/amazon/redshiftodbc/lib/64/libamazonredshiftodbc64.so

Issue

Observed Behavior when using 4.0.34 version -

pyodbc.connect("DSN=fview_redshift_TEST;UID=svcdev;PWD=****")
Traceback (most recent call last):
File "", line 1, in
pyodbc.Error: ('HY000', '[HY000] [unixODBC][Amazon][ODBC] (11560) Unable to locate SQLGetPrivateProfileString function: [Amazon][DSI] An error occurred while attempting to retrieve the error message for key 'LibsLoadErr' with message parameters ['""'] and component ID 3: Message not found in file "/opt/amazon/redshiftodbc/ErrorMessages/en-US/ODBCMessages.xml" (11560) (SQLDriverConnect)')

Observed behavior when using 4.0.32 version -

pyodbc.connect("DSN=fview_redshift_TEST;UID=svcdev;PWD=****")
<pyodbc.Connection object at 0x7f8984561810>

Seems like an update broke the connection to AWS Redshift. Please suggest.