|
Home > Archive > BizTalk Server General > July 2005 > Syntax error converting datetime from character string
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Syntax error converting datetime from character string
|
|
| s.ocallaghan 2005-07-28, 5:52 pm |
| 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
| |
| Marvin Smit 2005-07-29, 8:03 am |
| 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
|
|
|
|
|