Activities

September 2010
M T W T F S S
« Aug   Oct »
 12345
6789101112
13141516171819
20212223242526
27282930  

Running PHP+MSSQL on IIS

Recently I got a requirement to run a php application which is using MSSQL extension.  I have done to configure IIS to work with Php files and enabled MSSQL extensions on PHP. But the real thing is that I had not luck with able to run the site.  Got the error “canot establish the database connection” After a while search I found that “freetds” library wasn’t enabled on the php to use MSSQL connectivity.

You can download the freetds dll from the noodle repository from here http://download.moodle.org/download.php/dblib/php52/DBLIB_NOTS.zip

This zip containing two files and copy both zip files in “c:php” and “c:phpext” directory.  C”php has already added in my system path. Then find the proper php.ini and add the following line

“extension=php_dblib.dll “

After restarting IIS service  it’s  starts to work correctly 🙂

Before

After,

Cheers

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>