Why do I get error "Client unable to establish connection: SSL requested but not supported" when using the SQL Server ODBC driver?

If your SQL Server instance is configured to request an encrypted connection (ForceEncryption set to Yes), you must use the SSL version of the SQL Server ODBC driver. Otherwise, your connection will fail with the error "Client unable to establish connection: SSL requested but not supported."

To use the SSL version of the SQL Server ODBC driver, in your data source, set the Driver attribute to Easysoft ODBC-SQL Server SSL. For example:

[MY_SQLSERVER_DATA_SOURCE]
Driver = Easysoft ODBC-SQL Server SSL
Server = MYSQLSERVERMACHINE\MYINSTANCE
User = MYDOMAIN\myuser
Password = mypassword
Encrypt = No

Further information