PHP-CGI Installation Problem - PHP 5.1.2

We have been running PHP on our internal network since version 4-2-2 (Intranet Server running Windows 2000 SP4 Server and uses IIS5.0)

PHP was initially installed to run PHPBB and then vBulletin. Under the Application Mappings section of IIS (for the Default Web Site) I configured .PHP extensions to use D:\PHP\php.exe.

Obviously, since installing PHP v4.2.2, we have upgraded the runtime a few times - we now currently run PHP 5.1.2.

Although the version of PHP has been upgraded I have not changed the Application mapping for PHP - as websites defined on our Intranet server inherit settings from the default all sites still use C:\PHP\php.exe for App Mapping (rather than PHP-cgi.exe since version 5)

All sites have worked fine until I installed a new site for SubDreamer and changed the App Mapping to PHP-cgi.exe.

I now get the error -

Fatal error: Call to undefined function mysql_connect() in D:\server-name\includes\db\mysql.php on line 34

PHP Warning: PHP Startup: Unable to load dynamic library 'D:\PHP\ext\php_mssql.dll' - The specified module could not be found. in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'D:\PHP\ext\php_msql.dll' - The specified module could not be found. in Unknown on line 0 PHP Warning: PHP Startup: Unable to load dynamic library 'D:\PHP\ext\php_mysql.dll' - The specified module could not be found. in Unknown on line 0

PHP.ini has been amended to set extension-dir to D:\PHP\ext and the three DLL modules above can be found in the ext directory. The extension line in PHP.ini for the relevant modules has been un-commented

Changing the App Mapping back to php.exe the system works fine (except for the GD image library under SubDreamer which is how I found this problem in the first place)

Any clues?  
PKFIOMAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

hernst42Commented:
AFAIK the mysql-extension under php 5 needs a mysqlclient.dll of version 4.x. So check which mysqlclient.dll you have installed on your system and replace (after the backup of the old one) it with an uptodate version.
WaielEidCommented:
'D:\PHP\ext\php_mssql.dll'  is for MS SQL not MYSQL
as for php_mysql.dll

you can get it from here : http://pecl.php.net/package/mysql and add it to your ext direcrory
Some of these DLLs are not bundled with the PHP distribution. so you can find the dll in this site http://pecl.php.net 
siliconbritCommented:

On the release of version 5, PHP is no longer configured to support MySQL *by default*.  The support is still available, but you need to turn it on.  Details on this can be found on the PHP site at:

   http://uk.php.net/mysql

..with instructions on how to configure manually for Windows at:

   http://uk.php.net/manual/en/install.windows.manual.php

Please note that this was a well-publicised change in the PHP5 release.  Whenever you move to a new version of some infrastructure component, you should check the release notes.  These are in a file included with your PHP installation, and also published online at:

   http://uk.php.net/README_UPGRADE_51.php

..plus there is a complete guide to migration from 4.x.x to 5.x.x at:  

   http://uk.php.net/manual/en/faq.migration5.php

Good Luck

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.