Hi all

I have a CS 2007 and am trying to extract information from that using BT
2006 - specifically orders through the orders adapter.

I am getting an error in the eventlog on the BT Server and a "matching"
error in the eventlog on the CS Server. The essence of the error on the CS
Server is

System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be between
1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.



I have read through a previous thread where people solved the same issue by
setting the date found in the registry database of the BT Server under
Commer Server 2007 BizTalk Adapters/Orders/[Registry Key from RcvLoc Con
fig]
to a valid date.

This I have tried without any luck - I have experimented with different
dates and formats without it making any difference.

Does anybody have any suggestions or examples of valid dates I can try since
I am running out of ideas?

Thanks in advance

/Troels

[ Post a follow-up to this message ]

Can you send the full event log details?
Also, you problem could be caused by a datatime field being an empty string,
somewhere in your orders, line items, etc.

"trc" wrote:

> Hi all
>
> I have a CS 2007 and am trying to extract information from that using BT
> 2006 - specifically orders through the orders adapter.
>
> I am getting an error in the eventlog on the BT Server and a "matching"
> error in the eventlog on the CS Server. The essence of the error on the CS
> Server is
>
> System.Data.SqlTypes.SqlTypeException: SqlDateTime overflow. Must be betwe
en
> 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
>
>
>
> I have read through a previous thread where people solved the same issue b
y
> setting the date found in the registry database of the BT Server under
> Commer Server 2007 BizTalk Adapters/Orders/[Registry Key from RcvLoc C
onfig]
> to a valid date.
>
> This I have tried without any luck - I have experimented with different
> dates and formats without it making any difference.
>
> Does anybody have any suggestions or examples of valid dates I can try sin
ce
> I am running out of ideas?
>
> Thanks in advance
>
> /Troels
>
>
>
>

[ Post a follow-up to this message ]