Dreamweaver CS4 - MySQL connection errors

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
GaryKevinBanksAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jason C. LevineDon't talk to me.Commented:
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.
GaryKevinBanksAuthor Commented:
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
Jason C. LevineDon't talk to me.Commented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
GaryKevinBanksAuthor Commented:
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!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Adobe Dreamweaver

From novice to tech pro — start learning today.