Hi Folks,

I'm sure this is a pretty common error.  I've converted a date field
from a CSV schema file into a message (using the Custom Date Format
property in the CSV schema editor) and this works fine.

However, when I try to push this date field into a database I get the
following error:


HRESULT="0x80040e07" Description="Syntax error converting datetime
from character string."
ÿ<Root
xmlns:ns00="urn:schemas-microsoft-com:xml-updategram"><?MSSQLError
HResult="0x80040e07" Source="Microsoft OLE DB Provider for SQL Server"
Description="Syntax error converting datetime from character
string."?></Root>


Can anyone offer any quick assistance as to how I might resolve this?

Kind Regards,

Shaun O'Callaghan

[ Post a follow-up to this message ]

Hi,

it seems like (see the character infront of the XML), the encoding BOM
(Byte Order Mark) is still present when trying to load this into a
DOM.

Hope this helps,

Marvin Smit.

On Thu, 28 Jul 2005 11:33:12 -0500,
s.ocallaghan@qnet-uk-dot-com.no-spam.invalid (s.ocallaghan) wrote:

>Hi Folks,
>
>I'm sure this is a pretty common error.  I've converted a date field
>from a CSV schema file into a message (using the Custom Date Format
>property in the CSV schema editor) and this works fine.
>
>However, when I try to push this date field into a database I get the
>following error:
>
>
>HRESULT="0x80040e07" Description="Syntax error converting datetime
>from character string."
> ÿ<Root
>xmlns:ns00="urn:schemas-microsoft-com:xml-updategram"><?MSSQLError
>HResult="0x80040e07" Source="Microsoft OLE DB Provider for SQL Server"
>Description="Syntax error converting datetime from character
>string."?></Root>
>
>
>Can anyone offer any quick assistance as to how I might resolve this?
>
>Kind Regards,
>
>Shaun O'Callaghan

[ Post a follow-up to this message ]