Having difficulty connecting to my remote server database, what am I missing?

In the yellow bar Dreamweaver informs me that: "Dynamically related files could not be resolved because your credentials don't allow file activity on the server." I'm quite new to al lthis so I'm not sure what the problem is or where it is. SO I try describe the problem with screenshots.

I have set permissions to be allowed to connect from my IP adress in hostgator.

The first two images are of me trying to add a recordset. I get the error that Dreamweaver can't connect to _mmServerScripts. Yet mmScripts i located on the root of the site at home/the ace as in other screenshots.

The image on the left shows the error I get when I run the test. All the fields in it are filled out the same way as on the screen on the right except I add the "Root Directory" home/theace.

Without adding the root directory(same as on the right screeenshot) I get succesfull connection to the SERVER

Database screen                                   

_mmServerScripts is in home/theace

Sorry for the screenshots I find it as the best way of explaining!