MSSQL

• http://stackoverflow.com/questions/15750711/connecting-to-sql-server-2012-using-sqlalchemy-and-pyodbc
• https://blog.afoolishmanifesto.com/posts/install-and-configure-the-ms-odbc-driver-on-debian/

Install unixodbc version > 2.3.0

sudo apt-get remove libodbc1 unixodbc unixodbc-dev

wget ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.4.tar.gz
tar zxvf unixODBC-2.3.4.tar.gz 
cd unixODBC-2.3.4/
./configure --enable-gui=no --enable-drivers=no --enable-iconv --with-iconv-char-enc=UTF8 --with-iconv-ucode-enc=UTF16LE --libdir=/usr/lib/x86_64-linux-gnu --prefix=/usr --sysconfdir=/etc
make
sudo make install

Download Microsoft ODBC Driver 11 for SQL Server® - RedHat Linux (RedHat6\msodbcsql-11.0.2270.0.tar.gz) and unpack (version 13 does not work)

check libraries

ldd bin/sqlcmd-11.0.2270.0

sudo ln -s /usr/lib/x86_64-linux-gnu/libcrypto.so /usr/lib/x86_64-linux-gnu/libcrypto.so.10
sudo ln -s /usr/lib/x86_64-linux-gnu/libssl.so /usr/lib/x86_64-linux-gnu/libssl.so.10
sudo ln -s /usr/lib/x86_64-linux-gnu/libodbc.so /usr/lib/x86_64-linux-gnu/libodbc.so.1
sudo ln -s /usr/lib/x86_64-linux-gnu/libodbcinst.so.2 /usr/lib/x86_64-linux-gnu/libodbcinst.so.1

sudo bash ./install.sh install --force

check timeout to localhost (no MSSQL server on linux host !!!)

sqlcmd -S localhost