sqlserver ce Valid Date Converted to Null

  • Thread starter Thread starter jadidk
  • Start date Start date
J

jadidk

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
 
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?
 
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
 
Are you using parameters in your queries? If not, please see this:

http://groups.google.com/group/micr...E+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).
 
Back
Top