node.js - 类型错误 : The "config.server" property is required and must be of type string

Question

面对错误

Database Connection Failed! Bad Config: TypeError: The "config.server" property is required and must be of type string. at new Connection (D:\License Generation\node_modules\tedious\lib\connection.js:87:13) at base.Promise (D:\License Generation\node_modules\mssql\lib\tedious.js:237:23) at new Promise () at ConnectionPool._poolCreate (D:\License Generation\node_modules\mssql\lib\tedious.js:195:12) at ConnectionPool._connect (D:\License Generation\node_modules\mssql\lib\base.js:245:10) at PromiseLibrary (D:\License Generation\node_modules\mssql\lib\base.js:220:19) at new Promise () at ConnectionPool.connect (D:\License Generation\node_modules\mssql\lib\base.js:219:12) at Object. (D:\License Generation\dbConfig.js:6:2) at Module._compile (internal/modules/cjs/loader.js:689:30)

配置文件

//Database Configuration
const dbconfiguration = {
    server: 'xyz', 
    user: 'fdf',
    password: 'safgfg',
    database: 'License_Keys',
    port: 1433 
};
module.exports = dbconfiguration;

const sqlInstance = require('mssql');
const configFile = require('./app.config');

//connect to your database
const poolPromise = new sqlInstance.ConnectionPool(configFile.dbconfiguration)
.connect()
.then(pool => {
    console.log('Connected to MSSQL')
    return pool
})
.catch(err => console.log('Database Connection Failed! Bad Config: ', err))

module.exports = poolPromise;

Answer 1

直接使用必需的configFile，因为您从该文件导出单个const变量对象，所以不需要像configFile.dbconfiguration那样访问它

这应该有效，

sqlInstance.ConnectionPool(configFile)

注意:为了消除混淆，您也可以像这样导出数据库配置，

//Database Configuration
module.exports = {
    server: 'xyz', 
    user: 'fdf',
    password: 'safgfg',
    database: 'License_Keys',
    port: 1433 
};