PSA: The ODBC sslmode parameter for Redshift is case sensitive

When connecting to Redshift through an ODBC connection be aware that the value of the sslmode parameter is case sensitive and needs to be lower case.

The same is probably true for PostgreSQL. I haven’t done any testing testing to confirm this, but since Redshift is based off PostgreSQL and according to a note here it appears to be so.

Advertisements
PSA: The ODBC sslmode parameter for Redshift is case sensitive