Previously, when you use Adaptive Server ADO.NET Data Provider 1.15 or earlier,
or connect to Adaptive Server version 15.0.x or
earlier, and the application binds a datetime parameter to an invalid
datetime range, such as 01-01-0001, the Adaptive Server ADO.NET Data Provider returns
error 30122, Invalid datetime field. Year is
out of range
.
For Adaptive Server ADO.NET Data
Provider 2.155 that is connected to Adaptive Server 15.5, this behavior
has changed. In this case, Adaptive Server ADO.NET Data
Provider sends the date to Adaptive Server, and Adaptive Server
returns an error. The error code returned is 247, Arithmetic overflow
during implicit conversion of BIGDATETIME value 'Jan 1 0001 12:00AM'
to a DATETIME field
, or something similar.