LINUX-MSSQL
Appearance
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