Forum Discussion

CaldeiraG's avatar
CaldeiraG
Copper Contributor
May 11, 2022

ODBC drivers for Ubuntu 22.04

I recently installed Lubuntu 22.04 and following these instructions to install the ODBC drivers but apparently MS hasn't packaged msodbcsql18 or 17 for this version.   Any ETA for those to be relea...
steve60's avatar
steve60
Copper Contributor

Timothy_Quinn 

 

This is not working. 

Ubunto 22.04 is using openssl 3. Microsoft doesn't seem to care about updating their drivers to support openSSL 3. 

Currently they are only supporting openssl1 with ODBC driver 17.

We are currently exploring switching all our servers and clients data to PostgreSQL. That's approximately 300 clients data. The software is developed in house, so a switch from MS SQL will be a pain but it is do able. I know Microsoft doesn't care about this and never will, we are not big enough to matter to them. We are waiting till April first to see if there are any solutions from the linux community. It is the end of life for ubunto 20.04, as it will not be maintained any more. and all our servers will be upgraded to 22.04.  

 

Craig100's avatar
Craig100
Copper Contributor
Feb 23, 2023
You are right, I'm beginning to wish MS hadn't bothered trying to be trendy and produce a Linux version of SQL Server. If they're not going to keep it up to date, it's totally irrelevant and a waste of effort. Sorry, but it just is. People don't just host on Linux servers, sum of us develop on Linux desktop machines too. No way are we going to put ourselves at risk just because MS can't produce software in a competent fashion. Hopefully they'll improve in time, but it's time we don't have. So we have to muck about with Docker as before and ignore the so called "SQL Server for Linux". I bet they withdraw it soon anyway.
  • steve60's avatar
    steve60
    Copper Contributor
    Feb 24, 2023

    There are hacks to down grade Openssl 3 to V1 . but I don't see the logic in compromising one systems security for Microsoft.
    If you are developing in Python and Django there you can import pymssql. This does not require any Microsoft drivers however it is no longer maintained and you do have to modify a bit of code to make it work. Microsof and Mac both need to just be honest and say "We have no interest in working with anyone else. If you don't like it leave" instead of pretending to support different OS half the time. There are so many Database options out there that support all OS platforms that there is no need to develop in Microsoft SQL server. As a developer I will always support platforms that are universal, It just makes my life easy.
    They have one month to make a patch before we start switching all our clients over to postgress.

Resources