tips:db:mssql

MSSQL

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
  • tips/db/mssql.txt
  • Last modified: 2016/08/12 10:50
  • by scipio