This shows you the differences between two versions of the page.
| Next revision | Previous revision |
| tips:db:mssql [2015/09/17 09:02] – created scipio | tips:db:mssql [2016/08/12 10:50] (current) – scipio |
|---|
| |
| |
| http://stackoverflow.com/questions/15750711/connecting-to-sql-server-2012-using-sqlalchemy-and-pyodbc | * 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 | Install unixodbc version > 2.3.0 |
| <code> | <code> |
| | sudo apt-get remove libodbc1 unixodbc unixodbc-dev |
| | |
| wget ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.4.tar.gz | wget ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.4.tar.gz |
| tar zxvf unixODBC-2.3.4.tar.gz | tar zxvf unixODBC-2.3.4.tar.gz |
| </code> | </code> |
| |
| Download [[http://www.microsoft.com/en-us/download/details.aspx?id=36437|Microsoft ODBC Driver 11 for SQL Server® - RedHat Linux]] | 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> | <code> |
| /bin/bash install.sh verify | ldd bin/sqlcmd-11.0.2270.0 |
| </code> | </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> |