Solved

Dreamweaver CS4 - MySQL connection errors

Posted on 2012-04-03
4
1,173 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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

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…
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…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

831 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