[MySQL][ODBC 8.0(w) Driver]SSL connection error: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol

Steve_Nguyen — Thu, 09 Feb 2023 13:28:48 GMT

After upgrading MySQL ODBC drivers (to, for example, connect to MySQL 8.0), old tasks connecting to MySQL 5.5/5.6/5.7 as sources fail.

Error:

Cannot connect to ODBC provider,RetCode: SQL_ERROR SqlState: HY000 NativeError: 2026 Message:
[MySQL][ODBC 8.0(w) Driver]SSL connection error: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol

Environment:

Resolution:

With MySQL ODBC Client 5.3 or higher, the internal parameters must be set to point at the correct driver.

First, locate the exact name of the driver in the Windows ODBC Data Source Administrator.

Open the windows ODBC Data Source Administrator
Open the Drivers tab
Scroll to your MySQL ODBC driver. Example: MySQL ODBC 8.0 Unicode Driver
Copy MySQL ODBC 8.0 Unicode Driver. This will be the name we use for the internal parameter.

Then set the Internal Parameter in Qlik Replicate.

In the Qlik Replicate Web Console, go to Manage Endpoint
Locate your MySQL Source or Target that is failing with the connection error
Switch to the Advanced tab
Click Internal Parameters
In the top search bar, type provider (for source) or driver (for target)
Click the suggestion. It will add a Parameter to define.
In Value, paste the name of your driver, replacing the <x.x> with the actual version: MySQL ODBC
Click OK

article [MySQL][ODBC 8.0(w) Driver]SSL connection error: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol in Official Support Articles

[MySQL][ODBC 8.0(w) Driver]SSL connection error: error:1425F102:SSL routines:ssl_choose_client_version:unsupported protocol

Environment:

Resolution: