我想使用sequelize与Microsoft SQL连接。我找到了此链接http://docs.sequelizejs.com/manual/installation/getting-started.html
我用nodejs编写了下面的代码:
require('dotenv').config();
var express = require('express');
var app = express();
const Sequelize = require('sequelize');
const sequelize = new Sequelize(process.env.DB_NAME,null,null, {
dialect: 'mssql',
host: process.env.DB_HOST + "\\" + process.env.DB_SERVER,
operatorsAliases: false,
pool: {
max: 5,
min: 0,
acquire: 30000,
idle: 10000
}
});
sequelize.authenticate().then((err) => {
console.log('Connection successful', err);
})
.catch((err) => {
console.log('Unable to connect to database', err);
});
app.listen(process.env.PORT);
console.log('Starting Server on Port ', process.env.PORT);
但是当我运行代码时,我遇到了一个错误:
sequelize deprecated String based operators are now deprecated. Please use
Symbol based operators for better security, read more at
http://docs.sequelizejs.com/manual/tutorial/querying.html#operators
node_modules\sequelize\lib\sequelize.js:242:13
Unable to connect to database { SequelizeHostNotFoundError: Failed to
connect to USER-PC\SQLEXPRESS:1433-getaddrinfo ENOTFOUND USER-PC\SQLEXPRESS
at Connection.connection.on.err (C:\Users\User\Desktop\loginApp\node_modules
\sequelize\lib\dialects\mssql\connection-manager.js:98:22)
我做错了什么,我不能连接到数据库?
4条答案
按热度按时间pkwftd7m1#
xmakbtuz2#
ES6格式
pkln4tw63#
您需要提供mysql数据库名称、数据库的用户名和密码
vtwuwzda4#
如果您仍在寻找答案,以下是适用于Azure mssql的方法。请替换用户名、密码和服务器名称。如果您要连接到数据库中的特定数据库,请将数据库替换为数据库的名称,否则请将其删除