Yes, it can work. what you need to do is delete the mysql connection that is created when you installed PowerCMS. and then re-add the connection using Dynamic connection. Make sure to set up the Dreamweaver site correctly by having the powercms files at the root of the site.