{"id":1136,"date":"2017-10-14T06:56:56","date_gmt":"2017-10-14T11:56:56","guid":{"rendered":"http:\/\/blog.ls-al.com\/?p=1136"},"modified":"2017-10-14T06:56:56","modified_gmt":"2017-10-14T11:56:56","slug":"linux-mssql-client","status":"publish","type":"post","link":"https:\/\/blog.ls-al.com\/linux-mssql-client\/","title":{"rendered":"Linux MSSQL Client"},"content":{"rendered":"<p>Quick note on connecting to a MSSQL database from Linux using tsql from FreeTDS. FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases.<\/p>\n<pre class=\"brush: bash; title: ; notranslate\" title=\"\">\r\n$ tsql -S DEVSQL1 -U &lt;user&gt; -P &lt;password&gt;\r\nlocale is &quot;en_US.UTF-8&quot;\r\nlocale charset is &quot;UTF-8&quot;\r\nusing default charset &quot;UTF-8&quot;\r\n1&gt; select @@version\r\n2&gt; go\r\n\r\nMicrosoft SQL Server 2016 (RTM-CU1) (KB3164674) - 13.0.2149.0 (X64) \r\n\tJul 11 2016 22:05:22 \r\n\tCopyright (c) Microsoft Corporation\r\n\tDeveloper Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 &lt;X64&gt; (Build 9600: ) (Hypervisor)\r\n\r\n(1 row affected)\r\n\r\n1&gt; use DEVDB1\r\n2&gt; go\r\n1&gt; SELECT * FROM INFORMATION_SCHEMA.TABLES \r\n2&gt; go\r\nTABLE_CATALOG\tTABLE_SCHEMA\tTABLE_NAME\tTABLE_TYPE\r\nDEVDB1\t        TABLE_1  \tJPS_DN\t        BASE TABLE\r\n<\/pre>\n<p>Ref: https:\/\/tryolabs.com\/blog\/2012\/06\/25\/connecting-sql-server-database-python-under-ubuntu\/<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Quick note on connecting to a MSSQL database from Linux using tsql from FreeTDS. FreeTDS is a set of libraries<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,90],"tags":[],"class_list":["post-1136","post","type-post","status-publish","format-standard","hentry","category-linux","category-mssql"],"_links":{"self":[{"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/posts\/1136","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/comments?post=1136"}],"version-history":[{"count":0,"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/posts\/1136\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/media?parent=1136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/categories?post=1136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ls-al.com\/wp-json\/wp\/v2\/tags?post=1136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}