Windows - PHP/MySQL/win2k: mysql/mysqli extension(s) will not load

Environment: PHP 5.2.2 / MySQL 5.0.42-community-nt / Windows 2000 SP4 (IIS)

I would greatly appreciate any help I can get on this. This is a current roadblock to moving my project on.

I have had both PHP and MySQL running on this machine for some time now, but I cannot seem to get either the MySQL or MySQLi extensions to load into PHP. I am verifying this using the PHP function "get_loaded_extensions()".

The physical locations of the .dll files are:
C:\php\ext\php_mysql.dll
C:\php\ext\php_mysqli.dll
C:\php\libmysql.dll

In the php.ini file I have enabled the following:
extension=php_mysql.dll
extension=php_mysqli.dll

extension_dir ="c:\php\ext"

And my Windows system path is as follows:
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\Sy stem32\Wbem;C:\Program Files\MySQL\MySQL Server 5.0\bin;C:\php;C:\php\ext;

I have discovered the MySQL & MySQLi extensions are loaded when doing from the command line: php -m, but the modules are not showing as loaded when using "get_loaded_extensions()" in a script served through IIS.

Thanks in advance!

Make sure the php.ini that you are changing is the one that php is using. Also, for IIS you must stop and start the whole IIS service in the control panel (If I remember correctly, you cannot just stop and start the web server in the management console) to get changes made to php.ini to take effect.

Make a .php file with the following and browse to it -
In the top section of the output, there is a line that lists the actual php.ini that is being loaded (if any.)

You can also check in the output if the mysql or mysqli extensions are getting loaded.

Thanks for the reply.

Yes, I am sure the php.ini file that I am modifying is the one php is using.

Also, I know about having to stop/start the entire IIS service, sadly with to avail.

Finally, I have a test.php using phpinfo() and it is showing that php is indeed using the correct php.ini file, but not loading the mysql or mysqli extensions.

I would check the web serve log for errors. I believe on IIS that it uses the Windows event log.

Everything looks correct. About the only thing left would be a permissions problem. The Windows user account that IIS is running under needs to have permission to read the php installation folder.