我有安装了dotenv的node.js应用程序,并在.env文件中添加了以下配置
DB_HOST='localhost'
DB_Database=TheDatabasename
DB_USER=TheUser
DB_PASS=thePassword
DB_PORT=1433
我正在使用sqlserver,像下面这样叫dotenv:
const sql = require('mssql');
const dotenv = require('dotenv');
dotenv.config();
const config = {
user: process.env.DB_USER,password: process.env.DB_PASS,server: process.env.DB_HOST,database: process.env.DB_Database,port: process.env.DB_PORT,}
const poolPromise = new sql.ConnectionPool(config)
.connect()
.then(pool => {
console.log('Connected to MSSQL')
return pool
})
.catch(err => console.log('Database Connection Failed! Bad Config: ',err))
module.exports = {
sql,poolPromise
}
我收到以下错误:
Database Connection Failed! Bad Config: TypeError: The "config.options.port" property must be of type number.