I'm creating a recordset in Dreamweaver 8. It sees my connection, tables and fields but when I click "test" I just get a pop-up with an yellow apostrophe sign with a small Dreamweaver logo on it. No error code is displayed.

If i go into "advanced mode" and test it pulls up my "Test SQL Statement" and displays all records from the remote database. Then if I click "ok" and complete the recordset and try top open it in the bindings panel, I get a pop-up that says "DataSource" across the top with the word "error" underneath and nothing displayed in the field below. I hope someone else has had this issue.