Solved

Dreamweaver CS4 - MySQL connection errors

Posted on 2012-04-03
4
1,156 Views
Last Modified: 2012-04-09
I've been working with DWCS4 and dynamic sites for ages and with no real issues however I'm now getting the following error when trying to set up new dynamic pages using data from a proven database:

"Dreamweaver could not connect to your server. It's possible you may have set to work offline in the browser client (eg IE)"

All pages previously created within DW and containing recordsets seem to work fine; the bindings panels on each page displays the recordset and the data rows within each RS, the pages display as expected (on a variety of testing browsers - Firefox, Safari, IE) yet when trying to access / open tables under the databases tab and the preconfigured connection, the tables list shows "none".

I can't even set up a new connection (even tried in a new, temporary site).

Any ideas before I resort to re-installation of the entire application??

Thanks, in advance, for any thoughts / assistance.

Gary
0
Comment
Question by:GaryKevinBanks
  • 2
  • 2
4 Comments
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 37804593
Is this just one server/connection or every site?

Do you have a testing server set up or is the remote and testing server set to the same thing.
0
 

Author Comment

by:GaryKevinBanks
ID: 37804742
This seems to be failing in every site set up on my local testing server (running IIS). The "Live View" option in DW seems also to have been affected as it doesn't work with .php files (although I can preview them in 2 of my 3 browsers - Firefox, Safari). Page previews from my localhost don't appear in IE - I'm told I'm offline! (Apologies if I mislead you on this earlier)

I've tried setting up a new "TEST" site from scratch and get the following error when trying to set up:

"Dreamweaver cannot use the prefix you entered to display live data. Please double-check your site configuration or click Help for more information on how to correct this problem. (HTTP Error 12150)"

Site configuration shows:
Testing server model: PHPMySQL
Access: Local/Network
Testing server folder: C:\inetpub\wwwroot\SITENAME
URL prefix: http://localhost/SITENAME/

I've checked out the Help option (runs through how to set up the web server) and the error code (also some items here on EE that discus that) - means that when Dreamweaver attempts to evaluate the URL of the testing server, it can't.

Does this sound like a DW problem or a problem with the web server (IIS)?

Look forward to your thoughts.

Gary
0
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 500 total points
ID: 37809259
It sounds more like IIS received a patch and that's screwing up whatever DW is trying to do.

One test is to download the free trial for CS 5.5 and see if that will connect properly.  If so, it's a DW problem.  If not, it's likely an IIS problem.
0
 

Author Comment

by:GaryKevinBanks
ID: 37826381
Many thanks for the suggestions. I decided to reinstall DW, disabled / re-enable IIS a few times and eventually reset the modem / router. Seems to be working again now. Pretty convinced that it was the latter that finally did the trick!
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

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…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

707 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

16 Experts available now in Live!

Get 1:1 Help Now