StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POAdding extensions for MS SQL Server to PHP 5.3.9 ini file causes FastCGI Error on server
text
Body
copied!<p>I am attempting to get a drupal site to work with SQL Server. I have followed the instructions outlined <a href="http://learn.iis.net/page.aspx/246/using-fastcgi-to-host-php-applications-on-iis/" rel="nofollow">here</a> to get PHP working. Then I downloaded the drivers <a href="http://www.microsoft.com/download/en/details.aspx?id=20098" rel="nofollow">here</a> and unpacked them to my PHP/ext folder. I then wrote an awesome php test page consisting of the following piece of code. </p> <pre><code><?php phpinfo(); ?> </code></pre> <p>opened up a web browser and pointed to the file localhost/phpinfo.php. All works wonderfully. </p> <p>I then opened upt the installed .chm file that came with the php drivers for sql server and made the appropriate changes.</p> <p>Based on the following from my PHPInfo page:</p> <blockquote> <p>PHP Extension Build API20090626,TS,VC9</p> </blockquote> <p>I added the following lines of code to my php.ini file</p> <pre><code>[PHP_PDO_SQLSRV_53_NTS_VC9] extension=php_pdo_sqlsrv_53_ts_vc9.dll [PHP_SQLSRV_53_NTS_VC9] extension=php_sqlsrv_53_ts_vc9.dll </code></pre> <p>I then restart IIS and point back to my awesome phpinfo.php file and get the following: HTTP Error 500.0 - Internal Server Error C:\Program Files (x86)\PHP\php-cgi.exe - The FastCGI process exited unexpectedly</p> <p>with some lightweight recommended information on suggested things to look at for resolution. e.g. file access, folder access.<br> There is no rights issue IIS_IUSRS has execute rights on the PHP/ext folder. </p> <p>Anyone with ideas on how to resolve this? Am I missing something somewhere to make this work?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload