If you open the recordset and click the test button, does the recordset test OK?
try deleting the server scripts, go to Site -> Advanced -> Remove Connection Scripts
also, Delete the Dreamweaver Cache file from the users configuration folder:
http://www.webassist.com/tutorials/Common-installation-issues