Previously, when you use Adaptive Server OLE DB Provider 15.0 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 OLE DB Provider returns error
30122, Invalid datetime field. Year is out of
range.
For an Adaptive Server OLE DB Provider
15.5 that is connected to Adaptive Server 15.5, this behavior has
changed. In the 15.5 versions, Adaptive Server OLE DB 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.
