MS SQL ODBC Driver

Hello,

iam not so deep in the whole Linux world and i hope you can help me. I’ve made a clean Installation of a SLES 11 SP4 Server with default Settings for testing how to install MS SQL ODBC Drivers from Microsoft direct. I’ve followed the Instructions direct from Microsoft here:

https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017

When iam trying to install the Driver i get the following error:

Problem: nothing provides libcrypto.so.1.0.0()(64bit) needed by msodbcsql-13.1.9.2-1.x86_64
Solution 1: do not install msodbcsql-13.1.9.2-1.x86_64
Solution 2: break msodbcsql-13.1.9.2-1.x86_64 by ignoring some of its dependencies

I googled a lot but nothing helps. I get the same error if i make a clead Installation of SLES 12 SP3 and try to install the MS SQL ODBC Drivers. Does somebody knows what the Problem is?

While I think it is probably normal on a SLES 11 system unless you have
added the updated encryption module for openssl 1.x to be added, SLES 12
should come with that by default, so it looks like the RPM microsoft is
providing to you is not using the correct checks, or else your SLES 12 box
is really oddly configured: On mine I see libcrypto.so.1.0.0 under /lib64
and it is owned by the libopenssl1_0_0-1.0.2j-60.11.2.x86_64 package which
was installed by default. Also if I use either zypper or rpm to query for
that file, it shows up as being installed:

ab@ip-172-31-47-236:~> zypper wp 'libcrypto.so.1.0.0()(64bit)'
Command 'what-provides' is replaced by 'search --provides --match-exact'.
refresh' as root to update it.
Loading repository data...
Reading installed packages...

S | Name            | Summary                                     | Type
--+-----------------+---------------------------------------------+--------
i | libopenssl1_0_0 | Secure Sockets and Transport Layer Security | package

Perhaps get a cleaner install of SLES 12 SP3 (or SLES 15), or check if you
have that package, and then go from there.


Good luck.

If you find this post helpful and are logged into the web interface,
show your appreciation and click on the star below.

If you want to send me a private message, please let me know in the
forum as I do not use the web interface often.