note 96163 deleted from faq.databases by danbrown

Note Submitter: itkinon at yahoo dot com ---- Apache 2.2.14 /PHP 5.2.12/MS-SQL 2008 integration -------------------------------------------------- * Download Apache 2.2.14 for Windows Installer package 2008 32 bit http://httpd.apache.org/download.cgi --> apache_2.2.14-win32-x86-no_ssl - follow the defaults when installing Apache - stop Apache 2.2 service * Download PHP 5.2.12 Windows Zip package for Windows 2008 32 bit; (VC6 Thread Safe version needed for PHP used as an Apache module). http://windows.php.net/download/ --> php-5.2.12-Win32-VC6-x86.zip - Extract the archive to C:\PHP - Verify the installation: C:\PHP>php -v - set the Environment Variable PHPRC=C:\PHP - Rename 'C:\PHP\php.ini-recommended' to 'C:\PHP\php.ini' - Edit C:\PHP\php,ini file: modify: extension_dir = "C:\PHP\ext" uncomment: extension=php_mssql.dll - Add the lines below to "C:\Program Files\Apache Software Foundation\Apache2.2\conf\httpd.conf" PHPIniDir "C:/PHP/" LoadModule php5_module "C:/PHP/php5apache2_2.dll" AddHandler application/x-httpd-php .php - Add the lines below to "C:\Program Files\Apache Software Foundation\Apache2.2\conf\mime.types" application/x-httpd-php php application/x-httpd-php-source phps - Ensure that phpinfo.php file with the content: <?php phpinfo(); ?> is in the folder C:\Program Files\Apache Software Foundation\Apache2.2\htdocs - Start Apache 2.2 service - Verification of Apache/PHP integration: http://localhost/phpinfo.php --> 'PHP Version 5.2.12' info shows up - Verification whether mssql' module is loaded: c:\php\php -m All works like a charm. no additional steps needed ...