Have you ever tried to connect MSSQL through PHP ? If you are looking a way, then this would be most effective way of doing that.
These steps are done at CentOS by compiling Freetds and PHP from source. So let’s look at how to connect PHP code in Linux to MSSQL Server using Freetds .
1) Download latest stable Freetds version.
wget ftp://ftp.freetds.org/pub/freetds/stable/freetds-0.95.tar.gz (stable version at the moment )
2) Compile Freetds with following config.
./configure –enable-msdblib –enable-sybase-compat –prefix=/usr/local/freetds –with-tdsver=7.3
Then execute ‘make’ and ‘make install’ .
3) Add “/usr/local/freetds/bin” to ~/.bash_profile file
ex:- PATH=$PATH:$HOME/bin:/usr/local/freetds/bin
when above step is finished tsql command should work on the command prompt, so Let’s check tsql compatibility using following command.
[root@WEB_SERVER]# tsql -C
Compile-time settings (established with the “configure” script)
Version: freetds v0.95
freetds.conf directory: /usr/local/freetds/etc
MS db-lib source compatibility: yes
Sybase binary compatibility: yes
Thread safety: yes
iconv library: yes
TDS version: 7.3
iODBC: no
unixodbc: no
SSPI “trusted” logins: no
Kerberos: no
OpenSSL: no
GnuTLS: no
4) Compile php with following config.
To integrate mssql with php, you must compile php with following configuration. you can keep any other configuration as you need.
–with-pdo-dblib=/usr/local/freetds
Then execute ‘make’ and ‘make install’ .
5) Restart Apache
That’s all. feel free to comment here if you have any questions.!
2 comments
Mobile App Developers
September 4, 2015 at 5:38 pm (UTC 5.5) Link to this comment
That is an extremely smart written article. I will be sure to bookmark it and return to learn extra of your useful information. Thank you for the post. I will certainly return.
admin
October 28, 2015 at 10:23 pm (UTC 5.5) Link to this comment
You are most welcome 🙂