Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Web Programming > Adobe Web Programming > Dreamweaver (all versions)
|
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Dreamweaver (all versions) section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 18th, 2004, 12:26 PM
Authorized User
 
Join Date: Nov 2004
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default Dreamweaver 2004 & mySQL database connection

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?!
 
Old November 18th, 2004, 01:31 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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.
 
Old November 18th, 2004, 02:22 PM
Authorized User
 
Join Date: Nov 2004
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
:)
 
Old November 18th, 2004, 04:35 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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.
 
Old November 18th, 2004, 04:41 PM
Authorized User
 
Join Date: Nov 2004
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old November 18th, 2004, 05:09 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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.
 
Old November 18th, 2004, 06:00 PM
Authorized User
 
Join Date: Nov 2004
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

I only have one web server running

 
Old November 19th, 2004, 03:03 AM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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.
 
Old November 19th, 2004, 10:55 AM
Authorized User
 
Join Date: Nov 2004
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.
 
Old November 19th, 2004, 03:09 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

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


Cheers,

Imar





Similar Threads
Thread Thread Starter Forum Replies Last Post
Dreamweaver MX 2004 and MySQL ire MySQL 0 May 27th, 2006 06:39 AM
php, mysql, apache & dreamweaver seanhsueh PHP Databases 1 December 9th, 2005 08:12 AM
DreamWeaver MX 2004 with Access Database fskilnik Dreamweaver (all versions) 1 September 25th, 2005 09:50 AM
very urgent!!!!connection to database in DMX 2004 p2p Dreamweaver (all versions) 1 May 9th, 2005 02:48 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.