Solved

Cannot connect to mysql db with Dreamwever

Posted on 2006-07-22
8
446 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
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

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 …
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 Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

813 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now