'I have problem involved in Connection between nodejs and mssql
I tried running this code but it shows the following error
'ConnectionError: Failed to connect to LAPTOP-VNS3VHIC:1433 - self signed certificate
at C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\mssql\lib\tedious\connection-pool.js:70:17
at Connection.onConnect (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\tedious\lib\connection.js:1038:9)
at Object.onceWrapper (events.js:482:26)
at Connection.emit (events.js:375:28)
at Connection.emit (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\tedious\lib\connection.js:1066:18)
at Connection.socketError (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\tedious\lib\connection.js:1412:12)
at Socket.<anonymous> (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\tedious\lib\connection.js:1177:14)
at Socket.emit (events.js:387:35)
at emitErrorNT (internal/streams/destroy.js:106:8)
at emitErrorCloseNT (internal/streams/destroy.js:74:3) {
code: 'ESOCKET',
originalError: ConnectionError: Failed to connect to LAPTOP-VNS3VHIC:1433 - self signed certificate
at Connection.socketError (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\tedious\lib\connection.js:1412:28)
at Socket.<anonymous> (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\tedious\lib\connection.js:1177:14)
at Socket.emit (events.js:387:35)
at emitErrorNT (internal/streams/destroy.js:106:8)
at emitErrorCloseNT (internal/streams/destroy.js:74:3)
at processTicksAndRejections (internal/process/task_queues.js:82:21) {
code: 'ESOCKET',
isTransient: undefined
}
}
RequestError: No connection is specified for that request.
at Request._query (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\mssql\lib\base\request.js:493:37)
at Request._query (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\mssql\lib\tedious\request.js:363:11)
at Request.query (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\mssql\lib\base\request.js:429:12)
at C:\Users\dtvin\OneDrive\Máy tính\mssql\index.js:14:16
at Immediate.<anonymous> (C:\Users\dtvin\OneDrive\Máy tính\mssql\node_modules\mssql\lib\global-connection.js:56:7)
at processImmediate (internal/timers.js:466:21) {
code: 'ENOCONN'
}
undefined'
const sql = require('mssql')
const config = {
user: 'sa',
password: '123456789',
server:'LAPTOP-VNS3VHIC',
database: 'TestDb',
port: 1433
};
sql.connect(config , function (err) {
if(err) console.log(err);
let sqlRequest = new sql.Request();
let sqlQuery = 'Select * from Persons'
sqlRequest.query(sqlQuery , function(err , data) {
if(err) console.log(err);
console.table(data)
sql.close();
})
})
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
