Download ODBC Drivers for Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

Why do I get error "libssl.so.5: cannot open shared object file" when using the SQL Server ODBC driver?

On 64-bit Linux platforms, the Easysoft SQL Server ODBC driver with SSL support is linked against OpenSSL libraries in /usr/lib64. The SSL version of the driver depends on:

/usr/lib64/libssl.so.5
/usr/lib64/libcrypto.so.5

If you try to use the SQL Server ODBC driver with SSL support (or tdshelper) and get this error, either OpenSSL isn't installed or the libraries in your OpenSSL distribution don't use the naming convention the driver expects.

The following steps show how to install the necessary OpenSSL libraries on 64-bit SUSE Linux Enterprise:

  1. Install the openssl (x86_64) and openssl-devel (x86_64) packages.
  2. In /usr/lib64, create a link named libssl.so.5 that points to libssl.so: 
    cd /usr/lib64
ln libssl.so libssl.so.5
  3. Create a link named libcrypto.so.5 that points to libcrypto.so: 
    ln libcrypto.so libcrypto.so.5
  4. To test the OpenSSL libraries, start tdshelper, which should now run successfully: 
    /usr/local/easysoft/sqlserver/bin/tdshelper

Note If you only want to use the non-SSL version of the SQL Server ODBC driver and don't need to use tdshelper to assist you when creating data sources, installing the OpenSSL libraries is not necessary.