Forum Discussion
ODBC drivers for Ubuntu 22.04
https://askubuntu.com/a/1409311/112312
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
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.
RgdsWhen 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?
