Install pyodbc over msodbcsql on the old Ubuntu 14.04 LTS

get-pyodbc.sh

#!/usr/bin/env bash

# The library pyodbc requires unixodbc headers to compile, but the
# version of the unixodbc-dev provided by trusty mismatches that of
# unixodbc from the repository provided by Microsoft, so here I
# manually install the unixODBC with all things needed.
wget ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.1.tar.gz
tar xvf unixODBC-2.3.1.tar.gz
cd unixODBC-2.3.1/
./configure --disable-gui \
            --disable-drivers \
            --enable-iconv \
            --with-iconv-char-enc=UTF8 \
            --with-iconv-ucode-enc=UTF16LE
make
sudo make install
sudo ldconfig

# Note that the unixODBC manually installed above will shadow the
# unixodbc that will be installed as a dependency of msodbcsql17
# below, since the `/usr/local/' family of paths precede the `/usr/'
# family of paths.

sudo cat > /etc/apt/sources.list.d/mssql-release.list <<EOF
deb [arch=amd64] https://packages.microsoft.com/ubuntu/14.04/prod trusty main
EOF

sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com --recv-keys EB3E94ADBE1229CF
sudo apt update
sudo apt install msodbcsql17

pip install pyodbc