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

Math picture Math · Aug 20, 2020 · Viewed 8.3k times · Source

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

MJ X picture MJ X · Aug 20, 2020

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