An architectural mismatch has often led to issue like -
When trying to connect through a dotnet application it fails with the following error message: "ERROR [01000] [unixODBC][Driver Manager]Can't open lib '/opt/amazon/redshift/lib/libamazonredshiftodbc.dylib' : file not found"