Solved

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

  • 22 November 2021
  • 1 reply
  • 329 views

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-field
I have no date before 10-2-2010 and I have no dates after 22-11-2021

I have several several datetime-fields like 5-3-2020 00:00:00

Could the time being the problem ? How can i stil import alle records in TX ? 

 

 

icon

Best answer by Syed Yousuf 22 November 2021, 18:31

View original

1 reply

Userlevel 3
Badge +3

Hi Roland,

This guide Connect to MySQL using ADO.Net

mentions the same issue and a workaround using DateTime2 and

Using the Override Data Type feature

Reply