This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I have the current Lightspeed version running with SQLServer2012. In several tables when I do Add() and then SaveChanges() I get this error: "The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value." The Lightspeed properties shows a "DateTime" for this field, the SQL Server shows a "DateTime". The app.config LightSpeedContect dataprovider ="SQLServer2008". A search of the entire project shows no instalnce of "DateTime2" in any code. How do I get LightSpeed to use the DateTime of the field and not DateTime2? |
|
|
|
|
On SQL Server 2008 if you have a date time that falls outside of the range of a normal datetime (e.g. DateTime.MinValue) then we use a DateTime2 data type to send this to SQL Server. So the actual problem you will be hitting is that you are dealing with a date that is not covered by a datetime value in SQL Server. The range for a datetime is Jan 1, 1753 - Dec 31 9999 so check that the value you are using falls inside that range.
|
|
|
|
