Hi, I'm encountering an error when I try to connect to my mySQL server through Dreamweaver MX.
Dreamweaver says the testing server has been set up fine, but when I come to add a mySQL connection I input all my connection details and click "Select..." it brings up an allert followed by an error message, which both say the same thing...

The error reads
"1) There is no testing server running on the server machine.
2) The testing server specified to this site does not map to the http://localhost:/_mmServerScripts/MMHTTPDB.php URL. Varify that the URL prefix maps to the root of the site."

I have no clue what's going wrong and have tried countless solutions... can anyone help?!

Hi there,

Can you show us how you set up the info for Local, Remote and Testing server in your Site Definition dialog?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Of course I can...

[u]Local Info</u>
Site Name = Test
Local Root Folder = E:\My Documents\Unnamed Site 1HTTP Address = http://localhost:/


[u]Remote Info</u>
Access = Local/Network
Remote Folder = E:\v3\temp\php
(E:\v3 is my webservers document root)

[u]Testing Server</u>
Server Model = PHP MySQL
Access = Local/Network
Testing Server Folder = E:\v3\temp\phpURL Prefix = http://localhost:/


if you want to know anything else just let me know
:)

Well, there you go. Just as the error message (sort of) indicated:

http://localhost:/

Is not a valid address. Drop the colons:

http://localhost/

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Like I say I have tried loads of things, that being one of the first and it seems to work fine with the colons, so i left them there.
even without the colons it doesnt work

Whatever the problem may be, the colons shouldn't be there. Period (no pun intended).

So, it must be something with the root of your site.

When Dreamweaver verifies the server, it tries to create a file at the server, and then tries to request it. So, somehow, E:\v3\temp\php doesn't map to http://localhost.

What happens when you create a file called test.php in the temp\php folder. Can you then request it through http://localhost/test.php?

Are you running multiple Web servers??

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

no it'd be //localhost/temp/php/test.php

I only have one web server running

Well, in that case, your remote folder and testing folder should be

E:\v3
There should be a direct mapping between the root folder you set in DW and the root of your site.

So, when DW put a file like test.php in E:\ it can be requested as http://localhost/test.php

Once inside the root, you can create folders (directly or in DW) that then map to http://localhost/temp/php for example.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Tried it... I have tried everything I can think of.. I'm not a newcomer to Dreamweaver MX 2004, nor any of the macromedia products...
I have tried every obvious thing... I have mapped to the document root before with no luck, and tried again after your suggestion, still with no luck.
Even if I try to define the testing server is basic mode it doesnt work.
When I test the url http://localhost/ in basic mode it brings up an alert saying
"Dreamweaver cannot use the prefix you have entered to display live data. Please double-check your site configuration or click on Help for more information on how to correct this problem. (HTTP Error: 12029)"

I have been through the help files looking for information regarding this problem, and all it says is how to set it up, not anything on how to correct the problem, or even if it's related to my other problems.

In that case I am out of ideas. Like you said, it should work the way you described it.


Cheers,

Imar