Hi All. I'm doing some profiling of my app and it shows that mssql is where it is spending most of the time. I'm trying to get some clarify about what i might be doing wrong. I suspect it has to do with how I'm connecting to the DB but I'm unsure. I create a top level connection variable then have my query using that instead of having the query inside the call back of the connect. Could this be an issue? It works perfectly until I try to scale up.
I need to resolve my error
i have error as below :
ConnectionError: Unknown driver [object Object]!
at new Connection (C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\node_modules\mssql\lib\main.js:197:15)
at Object.module.exports.selectDataPackages (C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\server\models.js:118:18)
at C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\server\app.js:103:11
at Layer.handle [as handle_request] (C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\node_modules\express\lib\router\layer.js:95:5)
at next (C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\node_modules\express\lib\router\route.js:131:13)
at Route.dispatch (C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\node_modules\express\lib\router\route.js:112:3)
at Layer.handle [as handle_request] (C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\node_modules\express\lib\router\layer.js:95:5)
at C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\node_modules\express\lib\router\index.js:277:22
at Function.process_params (C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\node_modules\express\lib\router\index.js:330:12)
at next (C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\node_modules\express\lib\router\index.js:271:10)
at new Connection (C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\node_modules\mssql\lib\main.js:197:15)
at Object.module.exports.selectDataPackages (C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\server\models.js:118:18)
at C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\server\app.js:103:11
at Layer.handle [as handle_request] (C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\node_modules\express\lib\router\layer.js:95:5)
at next (C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\node_modules\express\lib\router\route.js:131:13)
at Route.dispatch (C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\node_modules\express\lib\router\route.js:112:3)
at Layer.handle [as handle_request] (C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\node_modules\express\lib\router\layer.js:95:5)
at C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\node_modules\express\lib\router\index.js:277:22
at Function.process_params (C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\node_modules\express\lib\router\index.js:330:12)
at next (C:\Users\Brst-Pc102\Documents\2NetU\nodeProject\netu\node_modules\express\lib\router\index.js:271:10)
Please provide me any resolution for this
resolve error
Anybody can help in this case?
is there a way to set Language for login? It uses all the time us_english instead language setled on db server for the login user.
The thing is that I'm trying to build an Angular 2 web application and I need a way to get data from an Microsoft SQL server. I thought I could use node in the background to access this data?
I'm using this tutorial to build the starting application https://scotch.io/tutorials/mean-app-with-angular-2-and-the-angular-cli
Or do you know a better way to build my application?
Check node mssql documentation on how to connect to mssql server
But now I'm getting the error: req.query is not a function
I cant give you direct answer
I just need to build an Angular 2 app with data from an SQL server
router.get('/posts', (req, res) => {
conn.connect(function (err) {
if (err) {
console.log("connection error -->" +err);
return;
}
req.query
if (err) {
console.log("query error -->" + err);
return;
}
else {
console.log(recordset);
res.send(recordset);
}
conn.close();
};
});
});
conn.connect(function (err) {
if (err) {
console.log("connection error -->" +err);
return;
}
req.query
SELECT TOP (10) u.* FROM [Alg].[User] AS u;, function (err, recordset) {if (err) {
console.log("query error -->" + err);
return;
}
else {
console.log(recordset);
res.send(recordset);
}
conn.close();
};
});
});
this is the code which gives the error
any help?
hi, i am trying to use the package inside a aws lambda. is there any walk through/example out there that shows how to get a connection, begin a transaction, commit/rollback transaction, close connection. etc. It seems that my code finds the connection open on subsequent calls to the lambda.
Basic question: I'm trying to refactor some code I wrote to use connection pooling asynchronously. The examples posted on the github repo are not sufficient for me to understand how to write the solution correctly. Are there any fully-featured example solutions in anyone's git repo I can look at? My app wants to open a sql connection pool and export execute methods for other modules to call upon. I am using koa wrapped around mssql to stand up an API backed by a sql database.
anyone, knows if is it possible to mantain 2 connections to 2 different servers?
The examples don't seem to be correct from what I can see.
dhensby on master
Update changelog for v5 Merge pull request #796 from dh… (compare)