PHP MySql Site Dreaweaver Error

Here goes

I'm building a php site that is suppose to connect to a mySql database in dreaweaver cs4.

I use Xampp to install Apache, PHP, MySql, phpMyadmin they work great I've tested the server and its fine.

I setup the site properly putting the folder in htdocs, the Url prefix is also as it should be. I've double checked these settings and visited a lot of tutorials.

When i preview the index page it works on the localhost.

The problem: is when i try and add a database to the page, i've created the database in phpMyadmin. In dreamwever CS4 wen i click the (+) sign in database and Click on Mysql Connection.

I filled the form as follow

Connection name: test
MySql Server: localhost
User name: (myusername)
Password: (mypassword)
Database: (database name)

I get this error message when i test:
Server timeout, reasons
1.Please make sure web server is up and running.
2.Please verify that the ODBC DNS exists on the testing server.

Any help would be greatly appreciated..:):):):):)