2878660 - DSConnectionManager connection to Amazon Redshift fails - Data Services

• Use the DSConnectionManager.sh to create an ODBC connection to Amazon Redshift and the connection test will fail.
  Error: "CON-120103: Initialization System call <LoadLibrary> to load and initialize functions failed for <InstallDIR/lib/libodbc.so.2>. Please make sure the shared library is installed and located correctly."
• Use the DSConnection/connection_test.sh to test the ODBC connection and the following errors will occur.
  
  Error: "CON-120307: Initialization ODBC call <SQLConnect> to connect database <Amazon Redshift ODBC DSN> failed with error: <ODBC call <SQLConnect> for data source <Amazon Redshift ODBC DSN> failed: <[Amazon][ODBC] (11560) Unable to locate SQLGetPrivateProfileString function.>"
  
  Error: "CON-120103: Initialization System call <LoadLibrary> to load and initialize functions failed for <InstallDIR/lib/libodbc.so.1>. Please make sure the shared library is installed and located correctly."
• Amazon Redshift ODBC variables are correctly defined.

• SAP Data Services
• Linux

KBA , EIM-DS-CON , Connectivity , EIM-DS , Data Services , Problem