Node-mssql: tedious deprecated

[Sandip75]

I am getting this message

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\libtedious\connection-pool.js:61:23

I am using
1 NodeJS: 12
2 node-mssql: "^6.0.1"

[dhensby]

then you will need to set the value to true or false explicitly to silence the message.

[shahramardalan]

I am getting this message

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\libtedious\connection-pool.js:61:23

I am using
1 NodeJS: 12
2 node-mssql: "^6.0.1"

//Initiallising connection string
let dbConfig = {
user: "sa",
password: "**",
server: "localhost",
database: "TEST",
"options": {
"encrypt": true,
"enableArithAbort": true
},
};

[dhensby]

So when the option is explicitly set you're still seeing the error?

[Sandip75]

Yes

On Thu, 2 Apr, 2020, 6:01 pm Daniel Hensby, [e-mail]
wrote:

So when the option is explicitly set you're still seeing the error?

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
https://github.com/tediousjs/node-mssql/issues/976#issuecomment-607817085,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/AHCQEEENVVR3GLSPYYTH5F3RKSATRANCNFSM4KJMNRDQ
.

[dhensby]

I'm afraid I cannot replicate this locally using the following test script:

test.js

'use strict'

const mssql = require('./')

const sqlConfig = {
  password: 'P@ssw0rd',
  database: 'master',
  stream: false,
  options: {
    enableArithAbort: true,
    encrypt: true
  },
  port: 1433,
  user: 'sa',
  server: 'localhost',
}

mssql.connect(sqlConfig)
  .then((pool) => {
    return pool.request().query('SELECT 1 as id')
  })
  .then((result) => {
    console.log(result)
  })
  .then(() => {
    return mssql.close()
  })
  .catch((err) => {
    console.log('error handler')
    console.error(err)
    return mssql.close()
  })

$ docker run -d --env ACCEPT_EULA=Y --env SA_PASSWORD=P@ssw0rd -p 127.0.0.1:1433:1433/tcp --name mssql docker.io/microsoft/mssql-server-linux:2017-CU9
$ cd ./node-mssql
$ git checkout 6
$ rm -rf node_modules/
$ npm i
$ node test.js
{ recordsets: [ [ [Object] ] ],
  recordset: [ { ID: 1 } ],
  output: {},
  rowsAffected: [ 1 ] }
$ docker stop mssql

Please provide any changes to my script that will replicate the problem

[rildomar]

I am getting this message
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\libtedious\connection-pool.js:61:23
I am using
1 NodeJS: 12
2 node-mssql: "^6.0.1"

//Initiallising connection string
let dbConfig = {
user: "sa",
password: "**",
server: "localhost",
database: "TEST",
"options": {
"encrypt": true,
"enableArithAbort": true
},
};

in my case, shows up two messages of deprecated and i needed to add on configuration these params:
"enableArithAbort": true and "trustServerCertificate": true

Sequelize 8.7.0
My configuration:

"development": {
    "dialect": "mssql",
    "seederStorage": "sequelize",
    "seederStorageTableName": "SequelizeSeed",
    "dialectOptions": {
        "server": "localhost",
        "authentication": {
            "options" : {
                "type": "default",
                "userName" :"MyUsername",
                "password" :"MyPassword"
            }
        },
        "options": {
            "database" :"MyDataBase",
            "enableArithAbort": true,
            "trustServerCertificate": true
        }
    }
  },

[LorneyZizzart]

I am getting this message
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\libtedious\connection-pool.js:61:23
I am using
1 NodeJS: 12
2 node-mssql: "^6.0.1"

//Initiallising connection string
let dbConfig = {
user: "sa",
password: "**",
server: "localhost",
database: "TEST",
"options": {
"encrypt": true,
"enableArithAbort": true
},
};

Me funciono gracias