Solved

Cannot connect to mysql db with Dreamwever

Posted on 2006-07-22
8
448 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: 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.

 

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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Suggested Solutions

Title # Comments Views Activity
Find & replace in Dreamweaver code to: add +1 to many id's 3 268
Dreamweaver Styles 7 405
Why does this script not work in this site 2 309
Multi Step Form using jQuery 11 957
For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
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…

763 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