ODBC: Client unable to create socket Error

Detail name	Value
Changelog Number	13215
Type	Bug
Status	Resolved
Affected Versions	Exasol 7.1.0
Fix Versions	Exasol 7.1.2
Resolution Date	2021-10-20

Description

When the ODBC driver is used in third-party software like Microsoft Excel, Alteryx, etc. the following error is raised

Client unable to create socket. Socket failure.

Workaround

Each of those workarounds avoid the error

• In the ODBC DSN configuration, add the parameter LoginTimeout (in seconds) and set it value greater than 0.
• In the ODBC DSN configuration, add the parameter LegacyEncryption and set it value to Y.
• Use Exasol ODBC 7.0 driver

LoginTimeout=1;

LegacyEncryption=Y;

Fix

The driver works correctly in such an environment without raising an error