Connecting To SQL Server From Linux

Kevin Feasel

2015-11-26

Linux

Erland Sommarskog has an article on ways in which you can connect to SQL Server from a Linux (or UNIX) box:

TDS — Tabular Data Stream — is the protocol that SQL Server talks with its clients. This is a proprietary protocol, owned by Microsoft (and Sybase, who have their version). Nevertheless there is exists FreeTDS which originally was a reverse-engineering effort of TDS. Now when Microsoft has published the TDS specification, they should be able to repair any cracks they may have. Check out the FreeTDS home page for further details. There appears to be a DBD::FreeTDS that goes along with it.

I used FreeTDS to connect to SQL Server from RStudio, so I endorse that method.

Related Posts

Installing SQLCMD On Linux

James Livingston shows us how to install SQLCMD on Red Hat Enterprise Linux: Microsoft has decent instructions on installing SQLCMD on linux. My current company blocks access to external yum repositories, so I followed the “Offline” installation. There’s two packages to install:1) msodbcsql – aka Microsoft’s ODBC driver for SQL Server2) mssql-tools – SQLCMD Read on […]

Read More

Changing Red Hat’s SSH Port On An Azure VM

Paul Randal has a post showing you how to change the default SSH port on a Red Hat Enterprise Linux VM hosted in Azure: The steps that need to be performed are:– Allow the new port in the RHEL firewall– Change the SSH daemon to listen on the new port– Add an incoming rule in the […]

Read More

Categories

November 2015
MTWTFSS
« Jan Dec »
 1
2345678
9101112131415
16171819202122
23242526272829
30