tips:db:mssql

This is an old revision of the document!


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 and unpack

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 bash ./install.sh install --force

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

sqlcmd -S localhost
  • tips/db/mssql.1442475322.txt.gz
  • Last modified: 2015/09/17 09:35
  • by scipio