This is solved now thanks
Just FYI, I have found that part of the connection issue is Dreamweaver's default URL (website address) in the site configuration.
After setting up FTP the website URL defaults to ftp.websitename.com so its trying to associate FTP as the website address. The FTP needs to be removed to read www.websiteaddress.com or websiteaddress.com. Once I removed that I had not trouble connecting to the database.