Re: need help please with MYSQL with IIS and PHP;Database connection not possible; error msg Invalid library

[Liang Zhao]

The latest php/connector was compiled with msvcr71.dll(Microsoft VC Runtime library).(New mysql connector is the same.)
This dll isn't available on some platforms. Forexample the new installation of Windows2000.
The .NET framework 1.1 has msvcr71.dll.
But in microsoft's document ,there said when you compiled with it you should redistribute it, just like other redistributed library.
but the new mysql/mysqli didn't do that.
So you must copy it into the directory which could find in 'path' system varible.
so the real mysql/mysqli connector has four library:

libmysql.dll (included in mysql's connector package)
php_mysql.dll (included in mysql's connector package)
php_mysqli.dll (included in mysql's connector package)
msvcr71.dll (if you do not have it, find it by yourself.is this a bug?)

Note:

Some other extensions are also need the msvcr71.dll to run.

For example: php_oci8.dll (Oracle database access module)

So make sure the msvcr71.dll could find in your path env-varible

some people didn't have this problem because some other software has installed this library into system.But if you config mysql's php-connector in a new installed windows system , you may have this problem.

In your case Although windows 2003 has .net framework but it not in your path env-varible, use search tools to find if you have msvcr71.dll in path.

but first you should fllow the php install instuctions, and didn't made mistake.