Re: sqlserver ce Valid Date Converted to Null

Are you using parameters in your queries? If not, please see this:

http://groups.google.com/group/microsoft.public.dotnet.framework.compactframework/browse_frm/thread/17306dd36cf55397/cf22ef25ebebd16a?q=Ilya+SQL+CE+parameters+Datetime&rnum=3#cf22ef25ebebd16a


Best regards,

Ilya

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

*** Want to find answers instantly? Here's how... ***

1. Go to
http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en
2. Type your question in the text box near "Search this group" button.
3. Hit "Search this group" button.
4. Read answer(s).

<jadidk@xxxxxxxxx> wrote in message
news:1134557343.057561.4490@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi Joseph,
> I tried that but it went through ok. I do't know if i have to check
> the regional settings or the sql server settings.It seems that sql
> server takes from the regional settings
>
> Rgds
>
> Jadid
> Joseph Byrns wrote:
>> Could it be that you are having region problems with your date format?
>> i.e.
>> US: mm/dd/yyyy and UK:dd/mm/yyyy. It seems a bit of a coincidence that
>> it
>> has happened on the 13th day of the 12th month, if you insert 2005-12-11
>> does that work?
>>
>> <jadidk@xxxxxxxxx> wrote in message
>> news:1134540449.758798.38470@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>> > Dear All,
>> > I have implemented a classical push/pull RDA synchronization with
>> > windows
>> > xp/IIS/sql server 2000 for 3 months now.
>> > Today without any warning i have been getting push errors due to
>> > inserting
>> > null date values .After checking the data,the date
>> > is ok (2005-12-13) but it still says that it cannot insert null date in
>> > the
>> > database
>> >
>> > Any Help most welcome
>> >
>> > Rgds
>> >
>> > Jad
>> >
>


.