SqlDateTime Overflow

[FrodoBaggins]

Dear Team,

Attempting to insert a record into a SQL database, using the command:

command.ExcuteNonQuery();

Get the following error message in the event log:

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

Have searched MSDN Library 2004 and online on MS site and can find nothing
relating to this bizarre error message.

Can you help?

Thanks,

Frodo.

 

[FrodoBaggins]

I should have stated the following in my original posting:

Am making the call from within a C# program within VS.NET 2003 (MS
Development Environoment 2003 Version 7.1.3088, MS .NET Framework 1.1
Version 1.1.4322) to an SQL 2000 database within MS SQL Enterprize Manager
Version 8.0, all installed on a Windows Server 2003 Standard Edition.

 

[FrodoBaggins]

And futher:

The record I am writing to contain no DateTime fields, just:

ID int 4 No nulls
allowed
Surname varchar 50 Nulls allowed
Firstname varchar 50 Nulls allowed.

Frodo

 

[FrodoBaggins]

Dear Team,

Ignore this question - I have managed to figure it out.

Thanks,

Frodo.

 

[FrodoBaggins]

Have sorted this problem out. Application was attempting to write to a date
field that did not exist.

 

[Felix Wu [MSFT]]

Thanks for sharing your experience, Frodo. It can probably benifit others
and help them fix problems.

Have a nice day!

Felix Wu
=============
This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------