ASP school website diary dates

[adamchapman]

I'm looking at ways that I can reduce the amount of time our school website takes to maintait in the way of updating diary dates, news items, vacancies etc.

 

I've designed plenty of websites before, but never touched anything data driven.

 

I'm trying to connect dreamweaver to Access or SQL database and keep getting various messages. The moust useful being "An unknown error has occurred" - great!

 

Does anyone currently do this kind of thing, or have any hints where I might be going wrong?

 

I'm using Dreamweaver CS3, testing server is a VM Win Server 2008 with SQL Express.

 

Any help would be appreciated guys...