Thanks for your reply. After defining a site in Dreamweaver CS6, I try to configure the SQL connection with the settings my web host has provided me with. Do you think it's the site definition? The site reports a successful connection. If so, perhaps the user name and password is the problem? Perhaps they should be the same because at the moment they are not the same? Any suggestions would be appreciated.
PS: James, do I need a root directory in the site definition?