Can't connect DW and database

Forum|Forum|19 years ago
January 15, 2007
4 replies
481 views

Hi There.

I have been using GoLive for years and always found it a very reliable and easy to use product. However I have to use a very simple database. Three small tables. I downloaded the trial version of Dreamweaver Studio 8 and have only looked at it briefly but all the reading that I have done says that this is the one for the job. I am having a problem though. I just cannot get dremweaver to connect to the MySQL database.

I have gone to the webserver itself and I got MySQL, through phpMyAdmin, to recognise that the database is installed and I can view all the fields. I ahve setup a user with all the privilages. But it doesn't seem to matter what I do I cannot get Dreamweaver to see it.

I get a "404 File Not Found" error. It also says " The testing server specified for this site does not map to the HTTP://www.mydomain.com/_mmServerScripts/MMHTTPDB.php?". I am obviously doing something wrong but for the life of me I just cant work it out.

I am using a MacBook but I also have a Dell and it is a similar result on the two of them. I have also trird installing the MAMP software and although the gui is very good, the results were no better.

Doey

Server side applications

This topic has been closed for replies.

I

iwantheman

Inspiring

It's your firewall, mate - tell it to grant Dreamweaver access and you'll be sorted - cheers

I

iwantheman

Inspiring

It's your firewall, mate - tell it to grant Dreamweaver access and you'll be sorted - cheers

M

Magic_Maker

Inspiring

David's explanation sounds pretty right to me, but I thought I'd add a little extra...

The Root foolder of your site may not be the default folder that your FTP account goes to. for instance, my site's root folder is a folder called www/ within my FTP account's default folder.

You may find that yours has a similar setup depending on your host.

A

Anonymous

Thanks Guys for the responce. You are correct in saying that I have to select the www folder when updating any pages through the ftp client. Unfortunatly I am not at that machine right now but I will try this out in a few hours when I am.

It all sounds very logical and matter of fact. So I hope to back on soon to tell you that this was the case.

Doey

N

Newsgroup_User

Inspiring

doeydude wrote:
> I get a "404 File Not Found" error. It also says " The testing server
> specified for this site does not map to the
> HTTP://www.mydomain.com/_mmServerScripts/MMHTTPDB.php?". I am obviously doing
> something wrong but for the life of me I just cant work it out.

Dreamweaver creates a hidden folder called _mmServerScripts in the root
folder of your website to handle all communication with MySQL. The error
message means that Dreamweaver can't find it because you have not set up
your Testing Server category correctly in your site definition.

It sounds as though you are using your remote server for testing. Go to
Site > Manage Sites, select your site, click Edit. Use the Advanced tab
and select the Testing Server category. Use the following settings:

Server model: PHP MySQL
Access: FTP
FTP host: the FTP details for your site
Host directory: the path to the root folder of your site
Login: your username
Password: your password
URL prefix: the URL that's the equivalent of the root folder of your site

The key is that Host directory and URL prefix must map to the same
location. So, if your site is called example.com, URL prefix will be
http://www.example.com/. Host directory is wherever you upload your home
page.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded