Path to Microsoft ODBC SSL Driver loaded libraries

Question

How do configure dynamic loading of OpenSSL libraries for use MS ODBC?

The Microsoft ODBC Driver for SQL Server on Linux version 17 dynamically loads the latest version of libssl based on its availability on the system.

Our software is linked custom build OpenSSL library. When we use Microsoft ODBC Driver that newest libssl loads from system paths to leading to a conflict and software crashes.

Is there a way to influence the libssl load path by the ODBC driver?

For example

1. Configure OpenSSL libraries to use (optional)

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-encrypted-connections?view=sql-server-ver16&source=recommendations&tabs=client

These symbolic links should be named libcrypto.so and libssl.so and placed in the /opt/mssql/lib/ directory.

2. Set the environment variable to indicate the libssl load path