On several occasions I have tried to set up to a database via Dreamweaver and I would get an error saying that Dreamweaver could not find a proper Testing Server. I have run in to this problem a few times now while working with Dreamweaver CS4 because I keep forgetting to write up what to do to handle it.
I went on to the Dreamweaver help page and the only thing I can say is that engineers should not write instructions, bahh, if I was smart enough to understand what is said, I could write my own programs like Dreamweaver! I will take this up another day.
Finally I remembered what I did in the past so here it is:
This is what you would you would do only after you have set up the site and remote server:
- SERVER MODEL: PHP MySQL
- ACCESS: FTP
- FTP HOST: ftp.site.com
- HOST DIRECTOR: (leave blank)
- LOGIN: login
- PASSWORD: password
- URL PREFIX: (this usually defaults to “http://ftp.site.com) change to “http://www.site.com”
This last line is where I usually screw up by keeping the default setting where I then spend the next 100 hours trying to figure this out.
Do take the note from Dreamweaver’s help page:
Note: As of Dreamweaver CS4, Dreamweaver no longer installs ASP.NET or JSP server behaviors. If you’re working on ASP.NET or JSP pages, however, Dreamweaver will still support Live Mode, code coloring, and code hinting for those pages. You do not need to select ASP.NET or JSP in the Site Definition dialog box for any of these features to work.




bandsxbands
February 2nd, 2010 at 16:44
My friend and I were recently talking about technology, and how integrated it has become to our daily lives. Reading this post makes me think back to that discussion we had, and just how inseparable from electronics we have all become.
I don’t mean this in a bad way, of course! Ethical concerns aside… I just hope that as the price of memory decreases, the possibility of downloading our memories onto a digital medium becomes a true reality. It’s one of the things I really wish I could encounter in my lifetime.
(Posted on Nintendo DS running R4 DS OperaMod)
Lupu
February 7th, 2010 at 09:51
Thanks.
I had the same problem…i’ve tried connecting 3 days to mysql and after reading you article it worked
Very usefull…
Jeff Carlson
February 7th, 2010 at 10:36
I glad that this helped. Let me know if you run in to any other trouble.
Ron
July 26th, 2010 at 11:34
Hi. Thank you for this awesome tutorial. It was of a great help. However the problem which I am facing is when I try to establish a mySQL connection after I have set up a testing server correctly (thanks to you).
When I click on select database in the create MySQL connection wizard it opens the file server dialog box and puts some files on my web host file server and then it says unidentified error occured. I really don’t know what to do. I you be grateful if you could help me.
Thanks,
Ron
Jeff Carlson
July 30th, 2010 at 06:42
Ron you are welcome. Email me at admin@linkedupdesign.com with which dreamweaver you are using and whether you are using Mac or Windows.
shawn
March 23rd, 2011 at 04:52
worked great thanks…. only 4hrs banging my head!!