Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Web Programming > Adobe Web Programming > Dreamweaver (all versions)
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old November 18th, 2004, 12:26 PM
Authorized User
 
Join Date: Nov 2004
Location: York, , United Kingdom.
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?!
Reply With Quote
  #2 (permalink)  
Old November 18th, 2004, 01:31 PM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 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.
Reply With Quote
  #3 (permalink)  
Old November 18th, 2004, 02:22 PM
Authorized User
 
Join Date: Nov 2004
Location: York, , United Kingdom.
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
:)
Reply With Quote
  #4 (permalink)  
Old November 18th, 2004, 04:35 PM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 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.
Reply With Quote
  #5 (permalink)  
Old November 18th, 2004, 04:41 PM
Authorized User
 
Join Date: Nov 2004
Location: York, , United Kingdom.
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

Reply With Quote
  #6 (permalink)  
Old November 18th, 2004, 05:09 PM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 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.
Reply With Quote
  #7 (permalink)  
Old November 18th, 2004, 06:00 PM
Authorized User
 
Join Date: Nov 2004
Location: York, , United Kingdom.
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

Reply With Quote
  #8 (permalink)  
Old November 19th, 2004, 03:03 AM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 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.
Reply With Quote
  #9 (permalink)  
Old November 19th, 2004, 10:55 AM
Authorized User
 
Join Date: Nov 2004
Location: York, , United Kingdom.
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.
Reply With Quote
  #10 (permalink)  
Old November 19th, 2004, 03:09 PM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

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


Cheers,

Imar
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 07:56 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.