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

Question

I try to connect to an oracle database in TimeXtende and i get the error "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM". 
I have no blanks in the datetime-fieldI have no date before 10-2-2010 and I have no dates after 22-11-2021I have several several datetime-fields like 5-3-2020 00:00:00Could the time being the problem ? How can i stil import alle records in TX ?

Syed Yousuf · Accepted Answer

Hi Roland,This guide Connect to MySQL using ADO.Netmentions the same issue and a workaround using DateTime2 andUsing the Override Data Type feature

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded