{"id":30,"date":"2016-01-24T21:39:31","date_gmt":"2016-01-24T21:39:31","guid":{"rendered":"http:\/\/www.e-gaulue.com\/en\/?p=30"},"modified":"2016-01-24T21:40:52","modified_gmt":"2016-01-24T21:40:52","slug":"microsoft-odbc-driver-13-for-sql-server-on-debian-jessie-installation","status":"publish","type":"post","link":"https:\/\/www.e-gaulue.com\/en\/2016\/01\/24\/microsoft-odbc-driver-13-for-sql-server-on-debian-jessie-installation\/","title":{"rendered":"Microsoft\u00ae ODBC Driver 13 for SQL Server on Debian Jessie installation"},"content":{"rendered":"<p><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/www.e-gaulue.com\/wp-content\/uploads\/2016\/01\/SQLSevrerUnionDebian-300x130.png\" alt=\"SQLSevrer Union Debian\" width=\"300\" height=\"130\" class=\"aligncenter size-medium wp-image-753\" \/><br \/>\nFor the version 11 of the Microsoft ODBC Driver for SQL Server on Debian Wheezy there was <a href=\"https:\/\/blog.afoolishmanifesto.com\/posts\/install-and-configure-the-ms-odbc-driver-on-debian\/\">this really good post<\/a>. Most of it remains usefull and here is just an update knowing everything is quite easier on jessie as the version of the unixodbc package manages those Microsoft drivers.<\/p>\n<p>The hardest is to take the right version of the ODBC driver on the Microsoft website. In version 11 only RedHat driver was released and its libraries were luckily supported by Debian (just changing their names). It&#8217;s not with version 13. However, Microsoft now offers several versions of the drivers including an &#8220;Ubuntu&#8221; one, closer to Debian. It is available at: <a href=\"https:\/\/download.microsoft.com\/download\/2\/E\/5\/2E58F097-805C-4AB8-9FC6-71288AB4409D\/msodbcsql-13.0.0.0.tar.gz\">https:\/\/download.microsoft.com\/download\/2\/E\/5\/2E58F097-805C-4AB8-9FC6-71288AB4409D\/msodbcsql-13.0.0.0.tar.gz<\/a>.<\/p>\n<p>The dependencies to install version 13 are:<\/p>\n<ul>\n<li>unixodbc: version 2.3.1 that comes with Jessie is enough (but optimizable by compiling a new version)<\/li>\n<li>libgss3: this is new in version 13<\/li>\n<\/ul>\n<p>Then the installation is limited to:<\/p>\n<pre lang=\"bash\">\r\nsudo apt-get install unixodbc libgss3\r\nwget https:\/\/download.microsoft.com\/download\/2\/E\/5\/2E58F097-805C-4AB8-9FC6-71288AB4409D\/msodbcsql-13.0.0.0.tar.gz\r\n-zxf tar-13.0.0.0.tar.gz msodbcsql\r\ncd-msodbcsql 13.0.0.0\r\nsudo .\/install install --force\r\n<\/pre>\n<p>NB: It looks possible not to use the <code>--force<\/code> option, but you&#8217;ll have to patch <code>install.sh<\/code> and deal with the installation of <code>odbc_config<\/code>.<\/p>\n<p>Once done, always run a small <code>ldd \/opt\/microsoft\/msodbcsql\/lib64\/libmsodbcsql-13.0.so.0.0<\/code> to ensure that all your dependencies are met and functional.<\/p>\n<p>Finally, you just have to use it knowing the installer automatically creates this entry in <code>\/etc\/odbcinst.ini<\/code>:<\/p>\n<pre> \r\n[ODBC Driver for SQL Server 13]\r\nDescription = Microsoft ODBC Driver for SQL Server 13\r\nDriver = \/ opt \/ microsoft \/ msodbcsql \/ lib64 \/ libmsodbcsql-13.0.so.0.0\r\nThreading 1 =\r\nUsageCount = 3\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>For the version 11 of the Microsoft ODBC Driver for SQL Server on Debian Wheezy there was this really good post. Most of it remains usefull and here is just an update knowing everything is quite easier on jessie as the version of the unixodbc package manages those Microsoft drivers. The hardest is to take the right version of the ODBC driver on the Microsoft website. In version 11 only RedHat driver was released and its libraries were luckily supported&#8230;<\/p>\n<p class=\"read-more\"><a class=\"btn btn-default\" href=\"https:\/\/www.e-gaulue.com\/en\/2016\/01\/24\/microsoft-odbc-driver-13-for-sql-server-on-debian-jessie-installation\/\"> Read More<span class=\"screen-reader-text\">  Read More<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[],"_links":{"self":[{"href":"https:\/\/www.e-gaulue.com\/en\/wp-json\/wp\/v2\/posts\/30"}],"collection":[{"href":"https:\/\/www.e-gaulue.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.e-gaulue.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.e-gaulue.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.e-gaulue.com\/en\/wp-json\/wp\/v2\/comments?post=30"}],"version-history":[{"count":7,"href":"https:\/\/www.e-gaulue.com\/en\/wp-json\/wp\/v2\/posts\/30\/revisions"}],"predecessor-version":[{"id":37,"href":"https:\/\/www.e-gaulue.com\/en\/wp-json\/wp\/v2\/posts\/30\/revisions\/37"}],"wp:attachment":[{"href":"https:\/\/www.e-gaulue.com\/en\/wp-json\/wp\/v2\/media?parent=30"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.e-gaulue.com\/en\/wp-json\/wp\/v2\/categories?post=30"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.e-gaulue.com\/en\/wp-json\/wp\/v2\/tags?post=30"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}