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.
"FrodoBaggins" <Fr**********@TheShire.com> wrote in message
news:e$**************@tk2msftngp13.phx.gbl...

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.

[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.
--------------------

From: "FrodoBaggins" <Fr**********@TheShire.com>
References: <e$**************@tk2msftngp13.phx.gbl>
Subject: Re: SqlDateTime Overflow
Date: Mon, 23 Feb 2004 11:03:09 -0000
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
Message-ID: <uF**************@tk2msftngp13.phx.gbl>
Newsgroups: microsoft.public.dotnet.general
NNTP-Posting-Host: m33-mp1.cvx1-a.bir.dial.ntli.net 62.255.36.33
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.general:125727
X-Tomcat-NG: microsoft.public.dotnet.general

Have sorted this problem out. Application was attempting to write to a date
field that did not exist.
"FrodoBaggins" <Fr**********@TheShire.com> wrote in message
news:e$**************@tk2msftngp13.phx.gbl...

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.