Jump to content

LINUX-MSSQL

From TetraWiki


Objective : Need to Connect to MSSQl Server Remotly from Linux Box.[edit]

# yum install php-mssql freetds
# vim /etc/odbc.ini < done the below Entry >

 [mssql]
Description             = MSSQL Server
Driver                  = freetds
Database                = interarchbuildings
ServerName              = MSSQL
TDS_Version             = 8.0
# vim /etc/odbcinst.ini < done the below Entry >

 [freetds]
Description = MS SQL database access with Free TDS
Driver      = /usr/lib/libtdsodbc.so.0
Setup       = /usr/lib/libtdsS.so.2
UsageCount  = 1
# vim /etc/freetds.conf < Done the below Entry >
[mssql]
   host = 182.18.165.201
   port = 1433
   tds version = 8.0
# /etc/init.d/httpd restart
# isql -v mssql interarchbuildings moki1805
Reff: for the tar installation 
http://richbs.org/post/43142767072/connecting-to-microsoft-sql-server-from-unix 
http://www.linuxjournal.com/article/6636
https://www.centos.org/forums/viewtopic.php?t=21567