SQL Server 2008 Datetime field overflow

Question

I am using C# to interface with a SQL database. the database has a DateTime field. When I try to write a DateTime object from C#, I get the following error:

ERROR [22008] [Microsoft][ODBC SQL Server Driver]Datetime field overflow

I found this on the topic:

http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/thread/ac1b5a6d-5e64-4603-9c92-b75ba4e51bf2/

Is there any manipulation I can do to my DateTime object on the C# side?

EDITS I am trying to add DateTime.MinValue

Answer 1

Sounds like you are just passing in a bad date. For example, DateTime.MinValue is outside the accepted range for SQL Server datetime values by about 1600 years.

By the way, you shouldn't be using ODBC for C# to SQL Server communication. Using System.Data.SqlClient will give you much better performance.