Solved

Cannot connect to mysql db with Dreamwever

Posted on 2006-07-22
8
449 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Dreamweaver CS6 keyboard shortcut 8 1,082
SWF won't scale? 4 535
xml to xml using xslt and php 4 563
Question about Dreamweaver CC 1 313
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
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…

710 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