Solved

Dreamweaver CS4 - MySQL connection errors

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Record Button 3 233
Unable to Connect Via FTP 109 1,317
Dreamweaver css dropdown will not show styles 8 715
Create recordset using Dreamweaver PHP and MS SQL 2008 4 596
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

739 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