且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用 sequelize 连接到本地 SQL Server 数据库

更新时间:2023-02-02 23:32:36

基于这篇文章 你应该安装 sequelize-msnodesqlv8:

Based on this article you should install sequelize-msnodesqlv8:

var sequelize = new Sequelize({
  dialect: 'mssql',
  dialectModulePath: 'sequelize-msnodesqlv8',
  dialectOptions: {
    instanceName: 'MSSQLSERVER01',
    trustedConnection: true
  },
  host: 'localhost',
  database: 'master'
});

或者更好:

var sequelize = new Sequelize({
  dialect: 'mssql',
  dialectModulePath: 'sequelize-msnodesqlv8',
  dialectOptions: {
    connectionString: 'Server=localhost\MSSQLSERVER01;Database=master; Trusted_Connection=yes;'
  },
});

但是您不应该将默认数据库保留为 Master.请改用您的数据库名称.

But you should not leave default database as Master. Use your database name instead.

标记:

node mssql 客户端很多,sequelize 默认使用乏味,但作为纯 javascript,乏味的 缺乏对集成安全.msnodesqlv8 是一个客户端,它与本机 odbc 库.这允许使用集成安全性.它确实需要额外的二进制文件来部署,但幸运的是,msnodesqlv8 与最常见的二进制文件一起分发架构

There are many node mssql clients and sequelize defaults to using tedious, but being pure javascript,tedious lacks support for integrated security. msnodesqlv8 is a client that interfaces with a native odbc library. This allows integrated security to be used. It does require additional binaries to deploy, but fortunately, msnodesqlv8 is distributed with binaries for the most common architectures

您正在使用集成安全性,因此您需要处理该问题.

You are using integrated security, so you need to deal with that problem.

另见这个问题.