Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

312
Views
Sequelize dialect dependency on msnodesqlv8

We are using sequelize package to connect to mssql server. Our backend code is in javascript.

We have a working code like below:

const sequelize = new Sequelize({
  logging:log,
  dialect:'mssql',
  dialectModulePath: 'msnodesqlv8/lib/sequelize'
  dialectOptions:{
   connectionString: process.env.connectionString,
   encrypt: false
  },
  operatorAliases: false
})

Below is the format of connectionString we are using in above snippet:

Driver={ODBC Driver 17 for SQL Server}; Server=<<Servername>>;Database=<<Database>>;Trusted_Connection=yes;

And in package.json I can see below 3 packages:

"msnodesqlv8":"^2.4.7",
"sequelize":"^4.41.2",
"sequelize-msnodesqlv8":"^0.2.6-beta.8"

In official doc of sequelize, I can see

const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect:'mssql',
  operatorsAliases: false,

  pool: {
    max: 5,
    min: 0,
    acquire: 30000,
    idle: 10000
  },

  // SQLite only
  storage: 'path/to/database.sqlite'
});

There is no mention about msnodesqlv8. Right now connection is working fine. But I was just trying to understand if sequelize uses tedious under the hood in order to have appropriate drivers so that connection to DB can be made. Then what is the use of msnodesqlv8?

In msnodesqlv8 official docs I can see it has some enhanced security features.

What I am trying to achieve by understanding this?

I want to remove the dependency of my code from msnodesqlv8 and snippet provided in official document of sequelize for mssql is not working for me.

Reason for removing dependency of msnodesqlv8?

We are migrating code to linux and msnodesqlv8 is compatible with linux which has dependency on msodbcsql17 driver which needs to be installed separately.

about 4 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!