Jump to content

LINUX-MSSQL

From TetraWiki
Revision as of 11:24, 31 December 2014 by Amit (talk | contribs) (Created page with "Category : PHP == Objective : Need to Connect to MSSQl Server Remotly from Linux Box. == # yum install '''php-mssql freetds''' # vim '''/etc/odbc.ini''' < done the ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)


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