Grid View and SQL Server Data WebDevelopment?

Question

I connected a SQL Data Source to my GridView and want to Insert Update and Delete. I checked the boxes when setting up the source for the Insert,Update, Delete and Optimistic concurrency. One of the columns shows a date and for some reason when I try to update or insert a row I get the following error:

The version of SQL Server in use does not support datatype 'date'.

Any ideas what it could be?

Answer 1

Sounds like you're trying to use the SqlClient engine with an Access database.