我正在尝试制作一个可以连接到我的sql Server数据库的rest API,但出现此错误:
ConnectionError:连接已关闭 在Request._query(...) 在Request.query(..) 代码:“ ECONNCLOSED”
这是我的代码:
var express = require('express'); // Web Framework
var app = express();
var sql = require('mssql'); // MS Sql Server client
// Connection string parameters.
var sqlConfig = {
user: 'username',password: 'mot de passe',server: 'localhost',database: 'DatabaseName',"enableArithAbort": true
}
// Start server and listen on http://localhost:8081/
var server = app.listen(8081,function () {
var host = server.address().address
var port = server.address().port
console.log("app listening at http://%s:%s",host,port)
});
app.get('/customers',function (req,res) {
sql.connect(sqlConfig,function () {
var request = new sql.Request();
request.query('select * from Sales.Customer',function (err,recordset) {
if (err) console.log(err);
res.end(JSON.stringify(recordset)); // Result in JSON format
});
sql.close();
});
})