The way that dreamweaver connects to your database is:
1) It uploads a _MMServerScripts folder to the root of the testing server site
2) It uses the web url to browse to the files in that folder
If it can't browse to the _MMServerScripts folder that is uploaded to the root of the site as defined in your site definition, and it can't browse to that folder using the website URL set in your testing server, then it won't be able to get data from the database.
If you want to send me your phone number then I'll do screen sharing with you to debug this and show you how to get it to work. I'm surprised that you are able to get the list of column names with this site setup, but I'm sure I can figure it out in a screen sharing session.