Dreamweaver MX MySQL connectivity on a Windows LAN

So there I was, driving myself nuts trying to figure out how to get my Dreamweaver MX on Mac OS X installation to connect to my IntranetΩs MySQL server via Mac OS XΩs built-in Samba client. I had tried everything substitute IP address for server name, local vs DNS names, variations on spelling and capitalization in my freakinΩ password, etc. Still nothing, and I was going insane.

There is a known problem with Dremweaver MX and PHP 4.1.0 due to a bug in mysql_pconnect(), but that wasn’t it since we were on PHP 4.0.4 old, but it should work nonetheless.

No, the problem is Samba itself, or at least the way Dreamweaver tries to use it. Switching to FTP connectivity to my Remote and Testing servers and substituting IP addresses instead of machine names solved my problem.

So if you’re having trouble with Dreamweaver MX for Mac OS X on a Windows LAN when trying to connect to your development server via Mac OS XΩs built in Samba client and nothing is happening, see if you can get to it via FTP.