"Type DATE is not a defined system type."

As Date columns aren't available in Sql Server 2005 so you have two choices:

1) Ask your hosting company to use Sql Server 2008 (or choose another host which does)

2) Use DateTime columns instead of Date

DATE is a new datatype introduced in 2008. It is not available in 2005.