Datetime data type conversion error ASP on IIS 7 when inserting date to SQL server 2005
Posted on 2011-02-16
When inserting a date to SQL server 2005 DB table datetime data type column from an ASP page running on IIS7 the following error occurs
Microsoft SQL Native Client error '80040e07' The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
This error does not occur when the ASP page is running on IIS6
Can you please help to resolve the issue