I am new to the whole PHP and MYSQL idea. My problem right now is that I installed everything. As in my IIS, PHP, MYSQL. I can access all three outside of dreamweaver. So I know htey all work fine. When I am in dreamweaver and try to setup the MySQL connection with the database it gives me a message that reads, "A unidentified error has occured.". Ive read online at the macromedia site and it says to do a couple of things like change info in the php.ini file or the connection file in dreamweaver connections directory. Neither worked. It also said to try and download the updater. But it wont install, keeps reading "Dreamweaver MX not in the directory." It is in the appropriate directory. Does anyone have any ideas? 2 days of trying is making me upset. lol. Thanks in advance for your assistance.
   -Jerry

What version of MySQL are you using?
Dreamweaver uses the OLD password system.
You can get more info at http://dev.mysql.com/doc/mysql/en/Old_client.html

Jim Martinson
[email protected]
Instructor - Computer Systems Technology
http://cst.ridgewater.edu http://JimMartinson.com
Ridgewater College - Hutchinson Campus
http://ridgewater.edu
2 Century Avenue S.E.
Hutchinson, MN  55350
1-320-234-0335
1-800-222-4424

I had the same problems and spent about a week with constant headaches over this problem, but allowing old passwords cured the "unidentifed error" problems, but trust me there will be a lot more to come, as I am currently experiancing at the moment...
Make sure you have your php.ini file set up to work with MySQL too.

Cool. Thanks everyone for all the help.
   -Jerry

I recently had the "An Unexpected Error has occurred" problem after setting up an existing site on a new computer and trying to connect to the database.

The solution for me was simple. A testing server has to be configured for database access to work. Since I was working with existing pages, it didn't notify me that I had forgotten to set up the testing server. After setting up the testing server, everything works fine.

Hope this is helpful to someone!

--
Brian

I have the same problem too.

how do I check the setup of my php.ini?

I remove the ';' of all the extensions in the php.ini file.

I tried few different suggestions but none of them work.
is it my server set, php or mysql setup?? I am confused


cheers

I am using apache 2.0.52, mysql 4.1.7, php 5.0.2, dreamweaver 7.0.1

(The forum added some underlines to this post. Please ignore the underlines.)

SUMMARIZING 4 TROUBLESHOOTING POINTS FOR MYSQL CONNECTION

1) In Dreamweaver, go to Sites/Manage Sites/Advanced, in “Testing Server,” be sure to configure URL prefix: http://localhost/ .... See Check the URL Prefix in the Site Definition at Macromedia.com. (Note that the URL prefix does not always need to point to http://localhost/. Right now, we are just using localhost as the troubleshooting web site. The important thing is for “URL prefix” to point to the document root address of whichever testing web site you are connecting to.)

2) Make sure that the MySql extension is activated in php.ini. Take the ; off the left side of the line in order to activate: extension=php_mysql.dll

3) Make sure that extension_dir = “c:\php\ext” is activated in php.ini, and that it points to the correct directory where php_mysql.dll is located.
      For PHP5: extension_dir = “c:\php\ext”
      For PHP4: extension_dir = “c:\php" Use this if you followed PHP4 installation instructions and copied all the extensions from c:\php\extensions to c:\php.

4) Make sure that PHP is working in Apache server. Does browsing to your http://localhost/phpinfo.php page display PHP graphics and data?

BLANK PAGES AND ERROR CODES IN DREAMWEAVER

The Dreamweaver Tutorial has you create PHP code on two pages: comments-view.php and comments-add.php. The problem is that after you complete the tutorial instructions, both pages display as blank pages in your Internet browser.
If you’re working on those pages in Dreamweaver, when you click on “Live Data View” you get the following error code:

The testing server did not execute any of the scripts in your document. Possible explanations include:
1) The testing server is not running.
2) The testing server ignores files with the ".php" file extension.
3) Your document does not contain any scripts.

 This is caused by a parsing problem in PHP, i.e the PHP code hangs up and your Apache server gives you a blank page. The solution is to make a change in the php.ini file. Change short_open_tag = on to make it read: short_open_tag = off

Good luck. I hope this helps.

REFERENCE: http://www.thriftyplaces.com/html/dr...hp___apac.html