Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Cannot connect to mysql db with Dreamwever

Posted on 2006-07-22
8
Medium Priority
?
452 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
Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

 

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 500 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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

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…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

772 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