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

[Bao Tonthat]

Hello,
I'm trying to build a page with RadScheduler and encounters issues with datatype 'date'.  Could some one give some help please?  Thank you in advance. 

Windows XP Pro
Visual Studio 2005
MS SQL 2005

Scenario:
1. Setup database structure for Appointments/Rooms/Users Tables  (Followed provided example from Telerik)
2. Build the page (Copy most of the sample code from Telerik)
3. Page loads the scheduler, enter information for a time slot, click "Save" button and get this error below:

 

Server Error in '/server' Application.

---

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

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: The version of SQL Server in use does not support datatype 'date'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ArgumentException: The version of SQL Server in use does not support datatype 'date'.] Telerik.Web.UI.Scheduling.DataSourceViewSchedulerProvider.OnDataSourceOperationComplete(Int32 count, Exception e) +16 System.Web.UI.DataSourceView.Insert(IDictionary values, DataSourceViewOperationCallback callback) +73 Telerik.Web.UI.Scheduling.DataSourceViewSchedulerProvider.Insert(RadScheduler owner, Appointment appointmentToInsert) +130 Telerik.Web.UI.Scheduling.AppointmentController.InsertAppointmentThroughProvider(Appointment appointment) +32 Telerik.Web.UI.RadScheduler.ProcessPostBackCommand(SchedulerPostBackEvent postBack) +182 Telerik.Web.UI.RadScheduler.RaisePostBackEvent(String eventArgument) +62 Telerik.Web.UI.RadScheduler.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +170 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2863

[Bao Tonthat]

Never mind!  I had it solved.  I went into the properties for "sqldatasource" and in Update/Insert change the date to datetime datatype and it works.