tips:db:mssql [Galileo Labs]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== 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
<code>
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
</code>

Download [[http://www.microsoft.com/en-us/download/details.aspx?id=36437|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
<code>
ldd bin/sqlcmd-11.0.2270.0
</code>

<code>
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
</code>

<code>
sudo bash ./install.sh install --force
</code>

check timeout to localhost (no MSSQL server on linux host !!!)
<code>
sqlcmd -S localhost
</code>