且构网

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

使用 sequelize 连接到 SQL Server 数据库时出错

更新时间:2021-07-20 22:33:41

答案是一个未公开的选项,称为方言选项.对于我的设置,为了连接到我们的 mssql 实例,这是必须的.

The answer was an undocumented option called dialect options. For my setup this was a MUST in order to connect to our mssql instance.

dialectOptions: {
    instanceName: INSTANCE_NAME_HERE,
    domain: DOMAIN_HERE
}

所以你的整个 Sequelize 实例/连接看起来像这样:

So your whole Sequelize instance/connection looks something like this:

var connection = new Sequelize(config.database,config.user,config.password, {
host: config.smallserver,
dialect: 'mssql',
pool: {
max: 5,
min: 0,
idle: 10000


},
    dialectOptions: {
        instanceName: config.instancename,
        domain: config.domain
    }
});

删除死链接