ODBC: Connection to pre-TLS DB may fail

Detail name	Value
Changelog Number	13527
Type	Bug
Status	Resolved
Affected Versions	Exasol 7.1.0
Fix Versions	Exasol 7.1.7
Resolution Date	2022-03-16

Description

The ODBC Driver is not able to connect to a database with does not have TLS support and has the -forceProtocolEncryption parameter set.

Databases supporting TLS are 6.2.15+, 7.0.10+, and 7.1.0+.

In these cases, the following error is shown:

ERROR: state 08004, code -373252, message [EXASOL][EXASolution driver]Connection exception - Client connection must be encrypted

Workaround

• Use Legacy Encryption to establish an connection by adding the parameter LEGACYENCRYPTION = Y.
• Update to a version with TLS support (6.2.15+, 7.0.10+, and 7.1.0+).

Fix

The driver detects these scenarios and falls back to the legacy encryption automatically.