Scaling of decimal value resulted in data truncation [ODBC214]

Question

Scaling of decimal value resulted in data truncation [ODBC214]

firebird-automations opened this issue 6 years ago · 2 comments

firebird-automations commented 6 years ago

Submitted by: R. Brown (rbrown)

When connecting to my firebird database via the ODBC connector using MS Access, the recordset is give me an error "Scaling of decimal value resulted in data truncation". The corresponding record is not shown. Is there a fix in the odbc to handle precision issues with decimals? Im using the Firebird/InterBase(r) driver 2.00.05.156. Thanks in advance for any guidance.

Answer 1 · 2019-01-22T01:48:22.000Z

Commented by: @alexpotapchenko

"Scaling of decimal value resulted in data truncation" is MS Access error, not Firebird ODBC.
You can search for this error message in internet, for example - https://cpltditdays.wordpress.com/2013/08/21/scaling-of-decimal-value-resulted-in-data-truncation/

Answer 2 · 2019-01-22T23:53:38.000Z

Modified by: @alexpotapchenko

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Won't Fix [ 2 ]

Fix Version: 2.0.6 [ 10851 ]