Skip to content

Latest commit

 

History

History
48 lines (36 loc) · 984 Bytes

create_connection_to_mssql.md

File metadata and controls

48 lines (36 loc) · 984 Bytes

Create Connection to Microsoft SQL Server

Install packages

sudo apt-get install -y unixodbc
sudo apt-get install -y unixodbc-dev
sudo apt-get install -y freetds-common 
sudo apt-get install -y freetds-dev
sudo apt-get install -y freetds-bin
sudo apt-get install -y tdsodbc

Edit configuration files

Add new server information into /etc/freetds/freetds.conf file

# /etc/freetds/freetds.conf
...
[MSSQLDev]
        host = 192.168.56.101
        port = 1433
        tds version = 7.0

Register FreeTDS driver with UnixODBC

  • create file /tmp/tds.driver.template contains this:
# /tmp/tds.driver.template
[FreeTDS]
Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so
  • run this command:
odbcinst -i -d -f /tmp/tds.driver.template

Test connection

# TDSVER=7.0 tsql -H <ip_addr> -p <port> -U <username>