How to solve the "Invalid scale value" error when using DataSynchronizer

Last update:
Created :
Written by Thomas Speekenbrink

Overview:

When you run your solution with DataSynchronizer, you might receive an error like:

Errors:
1: In element: Company on record: 0 last known primary keys: (contact.id:7097,address.id:7185,phone.id:14195,phone.id:14196,Email.id:7170) message: Database error: ERROR [HY104] [Microsoft][ODBC SQL Server Driver]Invalid scale value

Follow this KB article to solve this error message.

How to:

The error message shows 2 important things,

1) The ODBC driver which is being used on the server is off the wrong type and should be corrected.

The error message shows that the SQL Server Driver is being used instead. This is an old version which is only used for older SQL versions and talks an "older language" so to speak.

Solution: Change the ODBC connection on the server to SQL Native Client Driver 10.0 (or higher).

2) The solution might be "out of date" and needs to be updated

If changes are applied to the UDEF fields (any change!), then the solution must always be updated. Follow this KB article to solve this step.

Solution: http://kb.infobridge.com/hc/en-us/articles/203611512

If both points have been solved, then try to run your solution again.