请参阅以下代码:
var config = {
userName: 'sa',
password: 'myPassword',
server: 'myRemoteServer',
options: {
database: 'SampleDB',
encrypt: true,
trustedConnection: true
}
}
var connection = new Connection(config);
// Attempt to connect and execute queries if connection goes through
connection.on('connect', function(err) {
if (err) {
console.log(err);
} else {
console.log('Connected');
}它按预期工作,即我连接到数据库。但是,我想连接到localdb:
server: '(LocalDb)\\MSSQLLocalDB',当我试图连接到server:(LocalDb)\MSSQLLocalDB时,会出现一个错误:
"ConnectionError: Failed to connect to (LocalDb)\MSSQLLocalDB:1433 - getaddrinfo ENOTFOUND (LocalDb)\MSSQLLocalDB
at ConnectionError (c:\Node\SqlServerSample\node_modules\tedious\lib\errors.js:12:12)
at Connection.socketError (c:\Node\SqlServerSample\node_modules\tedious\lib\connection.js:1016:30)
at c:\Node\SqlServerSample\node_modules\tedious\lib\connection.js:861:25
at GetAddrInfoReqWrap.callback (c:\Node\SqlServerSample\node_modules\tedious\lib\connector.js:69:18)
at GetAddrInfoReqWrap.onlookupall [as oncomplete] (dns.js:72:17)"我花了两个小时研究这个。一些网页说(LocalDb)\MSSQLLocalDB是由node.js支持的,而另一些则说它不支持。我该怎么做呢?请注意,Server没有安装在本地主机上(只有)。
发布于 2020-03-14 20:28:35
请使用此连接字符串。
Data Source=.\sqlexpress;AttachDbFileName=e:...***.mdf;集成Security=True;
https://stackoverflow.com/questions/59090305
复制相似问题