How to fix the "Invalid precision value" error


This article explains what to do if the customer gets an “Invalid precision value” error.


Problem

The user gets the following “Invalid precision value” error error.

 

Solution

There are two possible scenarios that should be followed in order to correct the issue of “Invalid precision value”:

Scenario 1

If Adonis is locally installed on the user’s computer, please follow the below steps:

  • Go to the control panel

  • administrative tools

  • ODBC Data Sources (64-bit)

  • Drivers

  • Check is there are installed ODBC driver 11 for SQL Server and SQL Native Client 13 or 11

  • If they are not installed, please use the link below for the ODBC driver and install the driver that corresponds to the bit-value of the system, also please make sure that all the components are installed.

https://www.microsoft.com/en-us/download/details.aspx?id=36434

SQL Native Client 11 can be installed from the Adonis installation folder, please find “sqlncli” file and run it as administrator.

Scenario 2

If the user is using shortcuts to start Adonis, then ODBC driver 11 for SQL Server and SQL Native Client 13 or 11 need to be installed on the main computer/ server.

However, the user still needs SQL Native Client 13 or 11 drivers for his computer.