Aurelius TDatetime conversion error on SQL Server 2022 (Firedac + ODBC)

BIZ TMS Aurelius
1

Our application is using FireDAC with Microsoft SQL Server 2022 and ODBC v18 client (Microsoft is no more recommanding to use the SQL Native Client).
Aurelius is set to use FireDAC connectivity. An execpion is raied as soon as an object with a TDateTime feild set to 0 is flush to the database:

Project Project1.exe raised exception class EMSSQLNativeException with message '[FireDAC][Phys][ODBC][Microsoft][ODBC Driver 18 for SQL Server][SQL Server]The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.'.

Do you know how to solve this issue ?

Thanks
Stéphane

2

Aurelius doesn't do much on the database connection layer.
All it does is to build the FireDAC SQL, and set the parameters this way:

    Parameter.DataType := P.ParamType;
    Parameter.Value := P.ParamValue;

Have you tried to do so with a regular FireDAC dataset without using Aurelius to try to reproduce the issue?

In the case of a date time value, DataType should be ftDateTime.