May 11 2022 04:00 AM
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 released?
Related question: https://askubuntu.com/questions/1407533/microsoft-odbc-v18-is-not-find-by-apt
Thanks,
CaldeiraG
Jun 05 2022 10:46 AM
Jun 16 2022 12:37 PM
Jul 01 2022 03:20 PM
Jul 04 2022 12:30 PM - edited Jul 04 2022 12:33 PM
@AngeloJr - Confirmed on a XUbuntu 22.04 test VM:
sudo apt-get install odbcinst
sudo curl https://packages.microsoft.com/keys/microsoft.asc | sudo apt-key add -
echo "deb [arch=amd64] https://packages.microsoft.com/ubuntu/21.10/prod impish main" | sudo tee /etc/apt/sources.list.d/mssql-release.list
sudo apt update
sudo apt install msodbcsql18
Dec 15 2022 01:54 PM
@Timothy_Quinn This looked really promising but when I try this in Mint 21.0 the final step results in the following:-
sudo apt install msodbcsql18
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:
The following packages have unmet dependencies.
msodbcsql18 : Depends: unixodbc (>= 2.3.1)
E: Unable to correct problems, you have held broken packages.
If I try to install unixodbc I'm hit with another missing dependency:-
libodbc2 : Breaks: libodbc1 (< 2.3.9-1~) but 2.3.7 is to be installed
E: Error, pkgProblemResolver::Resolve generated breaks, this may be caused by held packages.
Etc, etc.
Really wish MS, having offered SQL Server for Linux, could keep up at least with the main LTS's. 22.04 has been out now for 8 months and MS will no doubt have had industry pre-knowledge. People are using it for development and production so it's now really important.
Rgds
Jan 22 2023 01:18 PM
When will this issue be resolved. Come April there will be no more official security updated for ubunto 20.04. all our servers will be upgraded to ubunto 22.04 with ssl3. Microsoft ODBC drivers do not support openSSL 3 as of yet. This is a huge problem is any one looking into this?
Jan 27 2023 03:08 AM
Feb 22 2023 02:23 PM
It appears that the instructions for installing ODBC on Ubuntu 22.04 and Debian 11.
I also got the v17 driver working on Linux Mint 21.1 as follows:
sudo su
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
curl https://packages.microsoft.com/config/debian/11/prod.list > /etc/apt/sources.list.d/mssql-release.list
exit
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get install -y msodbcsql17
# optional: for bcp and sqlcmd
sudo ACCEPT_EULA=Y apt-get install -y mssql-tools
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
To use v18, just change to line with msodbcsql17 to use msodbcsql18
Feb 23 2023 05:42 AM
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.
Feb 23 2023 06:16 AM
Feb 24 2023 05:59 AM - edited Feb 24 2023 06:00 AM
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.
Mar 24 2023 12:57 PM - edited Mar 24 2023 01:13 PM
My test Mint 21 system (Ubuntu 22.04.x based) was blocked from being able to be updated.
When I did a `sudo apt-get upgrade`, It failed and I was prompted to run `sudo apt --fix-broken install` which when was run would also fail due to the odbc drivers.
I followed these instructions to remove the offending packages: https://superuser.com/a/1439244/247361
It took a few tries and I had to remove `unixodbc-common`, `libodbc2`, `libodbcinst2`, `odbcinst1debian2` before `sudo apt --fix-broken install` would run ok.
I'm in the process of upgrading my test VM and will add notes if I hit a wall with this driver again.
[Update] - Afetr updating and trying `sqlcmd` it failed with `sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Can't open lib 'ODBC Driver 17 for SQL Server' : file not found`. To fix, I had to remove `msodbcsql17` and then re-install along with mssql-tools.
Mar 26 2023 12:36 PM
Hi @CaldeiraG , all
Option 1: According to Microsoft documentation it is well supported.
> In this quickstart, you install SQL Server 2022 (16.x) on Ubuntu 20.04.
Please follow this document:
Option 2: You can install Docker into Ubuntu 22.04.
(1) Install Docker Engine on Ubuntu:
https://docs.docker.com/engine/install/ubuntu/#set-up-the-repository
(2) Install SQL Server Container:
Mar 27 2023 05:28 AM
Already in the process of switching all our clients to PostgreSQL. It is way cheaper as well.
Mar 27 2023 06:34 AM - edited Mar 27 2023 06:35 AM
cheaper will be to use notepad
"cheaper" is just one parameter to take into consideration out of of tens of parameters, but we cannot know what best fit your needs, only you should know. Good luck with any decision to got.
Mar 27 2023 06:41 AM
May 16 2023 03:04 PM
Hi @steve60
> postgresSQL is a well balanced and well known database.
You are totally current. It is a great database server which can fit most cases. My last response was not related to this specific solution but just noted about the reason you mentioned "cheaper". I just wanted to emphasize that cheaper is just one parameter when you select the solution.
I am sure your will have an awesome system
Have a great day