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

score 22 · Accepted Answer · answered Aug 20 '20 at 00:20

22

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

answered Aug 20 '20 at 00:20

MJ X

8,506
12
74
99

2

I confirm, using latest mssql as of January 2021. Exactly. Thank you. – scavenger Jan 15 '21 at 06:17
2

This worked. I needed to explicitly define both `encrypt` and `enableArithAbort`. Thank you. – Laith Jun 15 '21 at 14:00

score 1 · Answer 2 · edited Jul 28 '21 at 17:01

The following worked for me :

const config = {

    user: 'sa',

    password: '<YOUR_PASSWORD>',

    server: '<COMPUTER_NAME>\\SQLEXPRESS',

    database: '<DBNAME>',

    requestTimeout: 180000, // for timeout setting

    connectionTimeout: 180000, // for timeout setting

      "options": {

        "encrypt": false, // need to stop ssl checking in case of local db

        "enableArithAbort": true

        }
}

score 0 · Answer 3 · answered Jul 04 '22 at 19:34

According to tedious docs and SET ARITHABORT

enableArithAbort: true // Ends a query when an overflow or divide-by-zero error occurs during query execution.  

encrypt: true, // A boolean determining whether or not the connection will be encrypted. Set to true if you're on Windows Azure.

score -1 · Answer 4 · answered Apr 16 '21 at 08:25

-1

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
}

answered Apr 16 '21 at 08:25

Hossein Mirzaei

5
3

1

and with the next npm install on another pc the problem is there again – Fluchaa Mar 15 '22 at 13:08

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

4 Answers4