Differences

This shows you the differences between two versions of the page.

--- tips:db:mssql [2015/09/17 09:02] – created scipio
+++ tips:db:mssql [2016/08/12 10:50] (current) – scipio
@@ Line 2: / Line 2: @@
-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
 <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
@@ Line 14: / Line 17: @@
 </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>
-/bin/bash install.sh verify
+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>

Galileo Labs

User Tools

Site Tools

Differences

Page Tools