Updated: 2019-02-07

Data Source Initialization OLE DB Property — «numeric_i2_rules»

Name:
numeric_i2_rules
Type:
VT_I4
R/W:
R/W
Default:
0
IBProvider:
3, 5

Rules for NUMERIC-columns with precisions 1..4. Can be zero or combination of following flags:

Value Description
1 NUMERIC with zero scale will be DBTYPE_I2.
2 Precision of NUMERIC will be 5 instead 4.

If you get the problems with NUMERIC and MSSQL (linked server), add to connection string «numeric_i2_rules=2».

See also

Other properties of group

Other sets of properties