i dont know if you have your questions answered, but i have used DW extensively, and the simplest way to connect to MS SQL server is to go to the "APPLICATIONS PANEL" then to the "DATABASE"
for a trusted connection, or specify the username and password parameters for the non trusted connection
Always click on the test connection
- Create an ODBC connection,
connections on the fly, ie the first are usually, said to be more reliable and faster.
In the next panel, which is the "bindings panel" you click on the plus button, and add a record set.
You could choose to add a recordset, or command object.
When the recordset dialog box appears, its simple and straightforward, I prefer to write my queries myself from scratch.
Then you could drag and drop the recordsets and db values into your ASP page. IN the server behaviours panel, you could see all dynamic objects in your page
Hope this helps