MsSql: Difference between revisions

Latest revision as of 16:02, 19 June 2015

Download "Microsoft ODBC Driver 11 for SQL Server on Linux" at Technet Microsoft Choose Redhat 6 version.

Extract the Archive

tar xvzf msodbcsql-11.0.2270.0.tar.gz

Validate dependencies.

cd msodbcsql-11.0.2270.0
ldd ./lib64/libsqlncli-11.0.so.1720.0

Install libssl1.0.0 to get libssl and crypto library

apt-get install libssl1.0.0

Create a link for missing library

cd /usr/lib/x86_64-linux-gnu
ln -s libssl.so libssl.so.10
ln -s libcrypto.so libcrypto.so.10

Force the installation

bash ./install.sh install --force

Validate

odbcinst -q -d -n "ODBC Driver 11 for SQL Server"

@@ Line 1: / Line 1: @@
 == Native Linux ODBC Driver==
 === Installation ===
-- Download Redhat Driver from Microsoft at
+Download "Microsoft ODBC Driver 11 for SQL Server on Linux" at [https://technet.microsoft.com/en-us/library/hh568451%28v=sql.110%29.aspx Technet Microsoft]
+Choose Redhat 6 version.
-extract the Archive
+Extract the Archive
 <pre>
 tar xvzf msodbcsql-11.0.2270.0.tar.gz
 </pre>
-- Install libssl0.9.8
+Validate dependencies.
+<pre>
+cd msodbcsql-11.0.2270.0
+ldd ./lib64/libsqlncli-11.0.so.1720.0
+</pre>
+Install libssl1.0.0 to get libssl and crypto library
+<pre>
+apt-get install libssl1.0.0
+</pre>
+Create a link for missing library
+<pre>
+cd /usr/lib/x86_64-linux-gnu
+ln -s libssl.so libssl.so.10
+ln -s libcrypto.so libcrypto.so.10
+</pre>
+Force the installation
+<pre>
+bash ./install.sh install --force
+</pre>
+Validate
+<pre>
+odbcinst -q -d -n "ODBC Driver 11 for SQL Server"
+</pre>