3537632 - DBCON connection to 'Azure Synapse' fails throwing error message "No shared library found for database..."

The customer set up a DBCON (database multiconnect) connection to a 'Azure Synapse' database which runs on a server other than the SAP NetWeaver host. 

In DBACockpit, testing the Database Connection in DBCON or in SE38, by executing report ADBC_TEST_CONNECTION, returns following error message:

"No shared library found for database..."  

- DBCON source system is: SAP NW BW ABAP 7.xy

- Target database is : 'Microsoft Azure SQL DB/Azure Synapse Analytics' cloud-based database.

Azure Synapse and Azure SQL Database are powerful cloud-based database solutions optimized for different types of workloads.
https://learn.microsoft.com/en-us/azure/synapse-analytics/overview-what-is

DBCON, database multiconnect, SQL Server, Microsoft Azure, Microsoft Azure Synapse, Cloud-Native, No shared library found for the database , with SQL Server Compatibility
SQL Server, ODBC, DBSL, dbacockpit, Iaas, PaaS, RDBMS, not supported , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BW-SYS-DB-MSS , BW on Microsoft SQL Server , Problem