Datatype mystery
Hi, I have recently installed the Microsoft Express Editions of Visual Web Developer 2005, and SQL Server 2005. I started following a tutorial, opened a new website, inserted a SqlDataSource, a DataGrid, and created a table, in which I used a datatype "smalldatetime". When I ran the program, and tried to edit a name, just to see how it works, I received this error "The version of SQL Server in use does not support datatype 'date'." The datatype "date" is not even in the list of datatypes! From the various Google searches I made, I did not find a resolution that worked. Can anyone help please, because it's driving me up the wall? I am using Windows XP SP3. Thanks in advance.
|