Hi all
I am receiving this error when I try to use Adobe Dreamweaver 8 to connect to mySQL database on the server.

"Your PHP server doesn't have the MySQL module loaded or you can't use the mysql_(p)connect functions"

I have googled this problem (at great length) and haven't been able to find a solution. Now you guys are my last best hope!

I am using PHP5 and mysQL 5.0.27 as well as using the mysqli.dll extension. I'm running IIS 6.0 on a Windows nt server.

I made sure the extension folder exists and i have edited the php.ini file to make sure the extension is not commented out and references to mysqli.dll. I have also copied the file mysqli.dll and libmysql.dll to the C:\Windows\System32 directory.

I have viewed the results for this same query on dozens of forums and tried every solution given but alas to no avail.

Any suggestions, no matter how inventive would be very well received.

Burnsie

Operating system running? Install paths of php and mysql?

1/ The MySQL server is set NOT to respond to external connections, only to localhost

2/ the MySQL user has localhost access only

3/ port 3306 (for MySQL) is not open through the server firewall.

Hi
Sorry i didn't make myself clear!
I am not trying to connect to an external server I am trying to connect on my machine using localhost.
The operating system is Windows XP Professional.
Cheers

I'm still new at this myself but are you starting mysql as well as Apache before you try to load the page?

DW adds a whole nuther level with which I have no experience.

does it all work when you open a page that connects to the SQL server in a browser?

Hi
I am running through Dreamweaver's tutorial (Cafe Townsend) as PHP is all a bit of a mystery to me.
When trying to test the mysql connection I get the error described above.
If I press the little 'select[database]' button in the Dreamweaver box I get the same error message OR one that reads:
PHP Startup: Unable to load dynamic library ‘C:\PHP\ext\msql.dll’ – The specified module could not be found.

If I use the MySQL Command Line Client I can see database and view its table.
cheers

I made sure the extension folder exists and i have edited the php.ini file to make sure the extension is not commented out and references to mysqli.dll. I have also copied the file mysqli.dll and libmysql.dll to the C:\Windows\System32 directory.

Have you also uncommented the lines for mysql.dll ?

Yep
I've done that too!

so do this then create a file called test.php place this in it

PHP Code:

<?php
phpinfo();
?>

then run it (ie open a browser and go to it) and look for MySQL. if it is loaded then it should appear in its own sub cat box thing. if it is not listed then the mysql php dll files are not being loaded by php.

I can't see any mention of MySQL!
Would it be listed under 'PHP Extension'?

Wonderful day
I have finally made the connection to the database!!!!
There was a clue in the question. The error message stated:
PHP Startup: Unable to load dynamic library ‘C:\PHP\ext\msql.dll’ – The specified module could not be found.
However, the files don't reside there, they are in 'Program Files' so in the php.ini file I changed under Paths and Directories:
extension_dir = "C:\PHP\ext"
to
extension_dir = "C:\Program Files\PHP\ext"
and hey presto it worked!!!
However, there is still no sign of 'MySQL' in the info file and annoyingly I still get the error message:
PHP Startup: Unable to load dynamic library ‘C:\Program files\PHP\ext\msql.dll’ – The specified module could not be found.
before I am connected to the database, but I guess I can live with that.

Cheers for all the input guys
Burnsie

So your php dir is in program files ???

So you are using MS SQL to for your database then? not MySQL? as there are differences between the two.

Once it is setup correctly you wont get any errors.

When you run that test.php script it should look like a standard html out put. and if mysql is running (I am assuming that you are still using mysql) it will have it's own table section with a header of mysql, or mssql if you are using that.

Also make sure that the php folder is readable by everyone so the web server can read the php files.

You are quite right, there is indeed a 'mysql' box in the info file (I didn't scroll far enough down the page!).
The install put all the PHP files in the program files. All seems to be working fine now but I do still get the error message on start up but then it goes away and everything works (as far as I can tell).