After some frustration, it found that Node JS mssql (5.0.5) doesn't like instance name in config file to make mssql.ConnectionPool(config)-
Works
dbConfig: {
"user": "user",
"password": "pass",
"server": "myserver", // Without instance name
"database": "dbname",
"port":1433,
"driver": "tedious",
"options": {
"instance":"mylocaldevdatabase",
"trustedConnection": true
}
}
Doesn't Work
dbConfig: {
"user": "user",
"password": "pass",
"server": "myserver\\myinstance", // With instance name
"database": "dbname",
"port":1433,
"driver": "tedious",
"options": {
"trustedConnection": true
}
}
Works
dbConfig: {
"user": "user",
"password": "pass",
"server": "myserver", // Without instance name
"database": "dbname",
"port":1433,
"driver": "tedious",
"options": {
"instance":"mylocaldevdatabase",
"trustedConnection": true
}
}
Doesn't Work
dbConfig: {
"user": "user",
"password": "pass",
"server": "myserver\\myinstance", // With instance name
"database": "dbname",
"port":1433,
"driver": "tedious",
"options": {
"trustedConnection": true
}
}
while making connection as in Node Js
import * as mssql from "mssql";
mssql.ConnectionPool(dbConfig)

0 comments :
Post a Comment