nodejs连接mssql出错,求解!

{ name: 'ConnectionError',
message: 'Failed to connect to msdbserver:1433 - getaddrinfo ENOTFOUND',
code: 'ESOCKET' }
代码如下:
var sql = require('mssql');

var config = {

user: 'sa',
password: 'sa',
server: '7Y5VITD3W2DT5VR\SQLEXPRESS', // You can use 'localhost\\instance' to connect to named instance
database: 'test',

options: {
    encrypt: false // Use this if you're on Windows Azure
}

}

var connection = new sql.Connection(config, function(err) {

// ... error checks

if(err) {
console.log(err);
}

// Query

var request = new sql.Request(connection); // or: var request = connection.request();
request.query('select * from user', function(err, recordset) {
    // ... error checks
    console.log(recordset);
    console.dir(recordset);
});

// Stored Procedure

var request = new sql.Request(connection);
request.input('userid', sql.Int, 10);
//request.output('output_parameter', sql.VarChar(50));
request.execute('proc_task', function(err, recordsets, returnValue) {
    // ... error checks

    console.dir(recordsets);
});

});

connection.on('error', function(err) {

// ... error handler

});

阅读 7.3k
3 个回答

已解决,是自己的表名没加上中括号和存储过程的参数传得不对...

连接失败,配置不对吧?

getaddrinfo ENOTFOUND 地址信息错误,找不到数据库

撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进
推荐问题