Solved

Cannot connect to mysql db with Dreamwever

Posted on 2006-07-22
8
447 Views
Last Modified: 2010-04-25
I'm trying to connect to a mysql db on a linux/plesk server using Dreamweaver MX 2004 and PHP.  When I try to set up the connection, I get "HTTP Error Code 404 File Not Found."  I've tried this with different domains on the server, with different db user accounts, and also with Dreamweaver MX with same results.  I am running DW on a Windows XP box.  I've tried the process both on a godaddy server and on a rackspace server.
0
Comment
Question by:msibley
  • 4
  • 4
8 Comments
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 17161837
Hi msibley,

I think you answered this, but can you connect to the MySQL server at all?
0
 

Author Comment

by:msibley
ID: 17161860
Yes, I can from the command line.  I can also run a PHP web script with a database query.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 17164931
Did you upload the Connections directory after you created the initial connection in DW?

Is there a _mmServerScripts directory present on the server?  Does it have MMHTTPDB.php and MySQL.php in it?
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:msibley
ID: 17165046
Not sure what you mean by Connections directory.  There is a _mmServerScripts directory with MMHTTPDB.php and mysql.php in it.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 17165053
There should also be a Connections directory on your local computer that holds a PHP file with the name of the connection you created from DW.  That directory needs to be uploaded to the server hosting the web site in order for the connection to work.
0
 

Author Comment

by:msibley
ID: 17167390
I see the Connections directory, but it is empty.
0
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 125 total points
ID: 17169490
Okay, you need to define a new connection in Dreamweaver. Once you do that, you should see a PHP file with the same name of the connection on the local site.  Upload the Connections directory to the server, then create a recordset to test.
0
 

Author Comment

by:msibley
ID: 17171156
OK, I finally got it working.

Thanks
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question