Using Dreamweaver to view database...

I am using Dreamweaver CS3.
I have successfully connected to a SQL Server database. However, I cannot wiew the database's tables when I try to expand the database (Application group, Databases tab). How can I get the tables to display?

Using Dreamweaver to view database...

This may be going back further than you want but if you have bound to the database as it seems you have, you need to create a page with a recordset (Simple interface) or (Advanced interface). Use the simple to see it working.

When you look in either of the above, you should see Tables, Views, Stored procedures with (+) symbols in front. Expand tables...

Create a simple select Query using this and then click OK.

Once out of there, you should be able to drag and drop items to your page.

Using Dreamweaver to view database...

Or, it could be something else. First, for some weird reason that I've never figured out, DW usually greys out the database in the panel that you're talking about unless you actually have a dynamic page open.?Sometimes it doesn't look greyed out, but when you click the plus sign, nothing happens.

Another issue coudl be when you do expand the database, it's unable to retrieve the tables.?In that case you'll get an error.?The same thing will happen when you go to create a recordset.?If that's happening, then you need to go to Site - Advanced - remove connection scripts, and reboot DW.?In some cases you also have to remove the connection from the site, then recreate it.?And like the above, you can't remove the connection from the panel unless you have a dynamic page open.

I alwaays make a back up of the connection file when I do that, because it will be deleted when you delete the database connection - then it's easy just to copy the?connection string from the backup file into the dialog box when setting up the connection again.