Node.js mssql error: tedious deprecated The default value for `config.options.enableArithAbort` will change from `false` to `true`

Question

I get the error below. How do I fix it?

tedious deprecated The default value for `config.options.enableArithAbort` will change from `false` to `true` in the next major version of `tedious`. Set the value to `true` or `false` explicitly to silence this message. node_modules\mssql\lib\tedious\connection-pool.js:61:23

Answer 1

Change your database config options to the following:

     var config = {
      user: 'username',
      password: 'password',
      server: 'localhost', 
      database: 'databasename',
      "options": {
        "encrypt": true,
        "enableArithAbort": true
        }
   };

read issue details here: https://github.com/tediousjs/node-mssql/issues/976

Answer 2

instead of setting in config in your project, set the value in node_modules node_modules/sequelize/lib/dialects/mssql/connection-manager.js.

options: {
   enableArithAbort: true,//<----------set this to true
   port: parseInt(config.port, 10),
   database: config.database,
   trustServerCertificate: true
}