node.js - 使用 sequelize 找不到 SQL Server 主机错误

Question

我正在尝试使用 sequelize orm 将 SQL Server 与 node.js 一起使用。但我不断收到找不到主机的错误:

HostNotFoundError [SequelizeHostNotFoundError]: Failed to connect to localhost//SQLEXPRESS:1433 - getaddrinfo ENOTFOUND localhost//SQLEXPRESS

Failed to connect to localhost//SQLEXPRESS:1433 - getaddrinfo ENOTFOUND localhost//SQLEXPRESS', code: 'ESOCKET

代码:

var db = new Sequelize('test', 'root', 'secret', {
    host: 'localhost\\SQLEXPRESS',
    dialect: 'mssql',

    pool: {
      max: 5,
      min: 0,
      idle: 10000
    },
  });

  db.authenticate()
  .then(()=>console.log('Database connected'))
  .catch(err=> console.log(err))

请帮我!

Answer 1

试
options.port 关系数据库的端口。

var db = new Sequelize('test', 'root', 'secret', {
  host: 'localhost\\SQLEXPRESS',
  dialect: 'mssql',

  pool: {
    max: 5,
    min: 0,
    idle: 10000
  },
  port:56198,
});