php5 mysql 4.1 iis: Cannot connect php5 pages to mysql DB

[bobcpg]

Running Xp Pro SP2 IIS, PHP5, and the latest mysql.

I can get php pages to display but cannot connect to DB's with php.

just did the auto install with php5 and heard you need to tweak some things to get it to connect to mysql's DB. I have added some PHP_mysql.dll to the php.ini but it still doesn't seem to be working.

questions:
1. what and how to add dll's to the php.ini

2. what directory should i put the php.ini, now its in the default c:\windows\php.ini

thanks, bob

 

[Drakkon]

the dll in the ini is just uncommenting a line (about 3/4 of the way down where all the dll's are listed)....you should have the ini file in the windows directory

make sure you ahve the dll availible from the directory where the ini points to where "extensions" are availbile

also make a script with a phpinfo() call to check on whats loading/not loading and you'll also get error windows as things go wrong

I'll add that you probobly will have to download the full zip of php 5 to get the extensions. Then take the extension you need (php_mysql.dll) and move it to the root directory of php (and in the ini use "./" as your default path). You will then probobly have to set a security setting to allow IUSR_COMPNAME (where compname is your computers name) to read/execute that dll file.