SQL Error, p. 412, step 11

member4953 · April 6th, 2009, 02:09 PM

Imar,

When I click "Insert" the browser returns this error:
The version of SQL Server in use does not support datatype 'date'.

The database definition for "UpdateDateTime" is "datetime". I tried entering only a date (04/06/2009 or 2009/04/06) and a date and a time (04/06/2009 14:02:00) but I still get the same error.

This machine at work has the full blown SQL Server Management Studio, i.e., not the Express version. I would not expect that that would be causing this error.

I deleted "AddEditReview.aspx" and did it over with the same results. I may have made the same mistake twice, but, if so, I cannot see it.

Thomas

Imar · April 6th, 2009, 02:21 PM

What version of SQL Server are you using? And what's the datatype of the reflected types in the parameters?

Imar

member4953 · April 6th, 2009, 02:41 PM

I am using SQL Server 2005.

From "AddEditReview.aspx"

Code:

        <InsertParameters>
            <asp:Parameter Name="Title" Type="String" />
            <asp:Parameter Name="Summary" Type="String" />
            <asp:Parameter Name="Body" Type="String" />
            <asp:Parameter Name="GenreId" Type="Int32" />
            <asp:Parameter Name="Authorized" Type="Boolean" />
            <asp:Parameter DbType="Date" Name="UpdateDateTime" />
        </InsertParameters>

OK, found it. I changed the "DbType" to "DateTime" and it worked. It was also in the "UpdateParameters".

It this something I should have known about or resulting from some setting that I should have made?

Thomas

Imar · April 6th, 2009, 03:11 PM

It used to work fine, before SQL Server 2008 came out. Once it was released, .NET / VWD was patched to support the new Date format, and it looks like it's inferring an incorrect type now. I have seen this before a couple of times.....

Imar