I'm having trouble setting up a database connection within Dreamweaver MX.

I've set up Apache, MySQL, PHP on my Windows 2000 Pro. My intention is to develop
and test on the same computer, then I will upload it to a web hosting account configured for
PHP. I've also installed Navicat from mysqlstudio.

All these installs are working fine. There is no IIS server on this machine, but it is
connected to a local network running Windows 2000 Server and both machines use a
router serving as a firewall between my local network and the internet. My Windows 2000
Server does NOT have Apache, MySQL, PHP, or DWMX installed on it.

I've created a new database in MySQL called "reason" with a single table in it called
"tbl_reason". I'm developing and testing on the Win2kPro client instead of the Win2k server
because I've read the Apache/MySQL/PHP configuration in Dreamweaver MX doesn't allow for
a separate testing server configuration. I've created a .php page within my Dreamweaver site
and that page is open within DWMX when I try to establish the database connection.

The local site is defined as:
C:\Apache Group\Apache\htdocs\recoilthe URL is defined as:
localhost/recoil/

My problem comes when I try to connect to my database from the Dreamweaver Database
connections panel. I enter:

connection name: reason
MySQL connection: localhost
User name: root
password: my_password
database: reason

I get in response:

An unidentified error has occurred.

When I use:
MySQL connection localhost/recoil
and type in the database name (instead of using the Select button), the database appears in
my list of connections, but there are no tables associated with it. I discovered in
Windows Explorer that that action simply created a reason.php file within the local site
connections folder. Do I need to create the MySQL database in that location instead of
at C:\MySQL\data? Do I need to identify some connection between
C:\Apache Group\Apache\htdocs\recoil\connection\ and C:\MySQL\data\?

I've also tried creating different users for the MySQL database. Any ideas?

Thanks,

savvycarol

I have exactly the same problem. Can anyone help me?