I am using ADO.Net to insert a record into a table. One of the fields is receiving the value from Now() (i.e. the current datetime). However, when I call the update method of the dataadapter I get the following error:

Sqldatetime overflow. Must be between 1/1/1753 12:00:00AM and 12/31/1999 11:59:59PM.

Why would this happen? I checked the settings on the server and it is set to interpret 2 digit dates between 1950 and 2049 so I know that's not the problem. What could be causing this? I've NEVER seen this happen before.

Please help!!!