Data Source Initialization OLE DB Property — «numeric_i16_rules»
Rules for columns and parameters with NUMERIC/DECIMAL datatype with precisions 19..38.
The property value can be zero or the combination of the following flags:
|1||NUMERIC with zero scale will be processed as INT128.|
|2||Precision of NUMERIC will be 39 instead 38. This mode is not supported by MSSQL.|
|4||Data has the type DBTYPE_WSTR. This flag was added in IBProvider v5.31.|
The valid values of this property: 0, 1, 2, 3, 4, 5.
If you get the problems with NUMERIC/DECIMAL (that is based on INT128) and MSSQL (linked server), add to connection string «numeric_i16_rules=4».
- Initialization property numeric_i2_rules
- Initialization property numeric_i4_rules
- Initialization property numeric_i8_rules
- Initialization property int128_rules