In this article I'll try to show a way to connect to MS SQL database using unixODBC package. I've got much info from this docs. I use Ubuntu 12.04 (64 bit) on my client machine.
The protocol for comunication between MS SQL client and server is called Tabular Data Stream (TDS). Brian Bruns started an open source project to provide an implementation of the TDS protocol to anyone who wanted it. This project is called FreeTDS. FreeTDS comes with several interfaces to TDS including ODBC (Open Database Connectivity).
2. Installing packages
So here the list of packages we need to be installed:
- tdsodbc (ODBC driver for connecting to MS SQL se...