Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Dreamweaver CS4 - MySQL connection errors

Posted on 2012-04-03
4
Medium Priority
?
1,192 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
[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
  • 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 1500 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

Enroll in September's Course of the Month

This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!

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 …
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 is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

705 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