Re: SqlDateTime Overflow
From: Felix Wu [MSFT] (felixwu_at_online.microsoft.com)
Date: 02/24/04
- Next message: HomeyDaClown: "How to save changes to datagrid from a Windows form in vb.net"
- Previous message: Travis 'Bailo' Bickel: "[OT] The Italian Job"
- In reply to: FrodoBaggins: "Re: SqlDateTime Overflow"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 24 Feb 2004 07:21:38 GMT
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" <FrodoBaggins@TheShire.com>
>References: <e$IrxTx6DHA.4060@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: <uFXZtyf#DHA.3428@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!tk2msftngp13.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" <FrodoBaggins@TheShire.com> wrote in message
>news:e$IrxTx6DHA.4060@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.
>>
>>
>>
>>
>
>
>
- Next message: HomeyDaClown: "How to save changes to datagrid from a Windows form in vb.net"
- Previous message: Travis 'Bailo' Bickel: "[OT] The Italian Job"
- In reply to: FrodoBaggins: "Re: SqlDateTime Overflow"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
