When you run an ODBC MySQL mapping that uses the MySQL ODBC 3.51 driver to write data to a MySQL target that contains a column with the Double data type, the mapping fails with the following error:
Column [A1_NUMBER_18_0] has scale greater than precision.
To resolve the error, upgrade to the MySQL ODBC 5.1 driver.
Before you configure an ODBC connection in
Data Integration
, you must create a system Data Source Name (DSN).