Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Jan 31 2019 14:34
    willmorgan commented on 889cbf1
  • Jan 31 2019 13:15
    gsamal commented on 889cbf1
  • Jan 31 2019 13:10
    dhensby closed #797
  • Jan 31 2019 13:10
    dhensby commented #797
  • Jan 31 2019 13:07
    dhensby closed #795
  • Jan 31 2019 13:07
    dhensby commented #795
  • Jan 31 2019 12:58
    gsamal commented #789
  • Jan 31 2019 11:50
    cesco69 opened #797
  • Jan 31 2019 10:22

    dhensby on master

    Update changelog for v5 Merge pull request #796 from dh… (compare)

  • Jan 31 2019 10:22
    dhensby closed #796
  • Jan 31 2019 09:53
    dhensby commented #789
  • Jan 31 2019 09:52
    dhensby commented #778
  • Jan 31 2019 09:51
    dhensby review_requested #796
  • Jan 31 2019 09:51
    dhensby opened #796
  • Jan 31 2019 06:45
    suckerp commented #795
  • Jan 31 2019 02:58
    liumorgan starred tediousjs/node-mssql
  • Jan 31 2019 02:15
    zhoukk starred tediousjs/node-mssql
  • Jan 30 2019 22:22
    vjpr edited #795
  • Jan 30 2019 22:22
    vjpr edited #795
  • Jan 30 2019 22:22
    vjpr opened #795
Peter Schwer
@schwer
it's the underlying drivers that are the issue in this case.
Jesse Ostrander
@jostrander
ah okay
Peter Schwer
@schwer
node-mssql just happens to be the most frequently used driver wrapper. We use the TDS driver via node-mssql in production. But reads only.
Jesse Ostrander
@jostrander
what are you using for writes currently?
Peter Schwer
@schwer
we have a perl cgi backend for that. Everything there has a tax ~750ms per operation.
Jesse Ostrander
@jostrander
ouch
Jerry Batorski
@jarekb84
is there a limit to how much data can be inserted via batch insert?
the data i'm trying to save is in the ballpark of 20 some mb
i'm getting an error in tedious's tracking-buffer\writable-tracking-buffer line 181
TypeError: "value" argument is out of bounds
hmm..might be an issue with saving a bigint
Jerry Batorski
@jarekb84
ok found it, was an issue with a value i wasn't expecting to be as big as it ended up being
Gil Ferreira
@misterGF
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.
lyminster
@lyminster
hy all i want to ask if there's a way to insert data to sql server database from excel using this MSSQL?
romykundal
@romykundal1_twitter
Hi,
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)
Please provide me any resolution for this
resolve error
Anybody can help in this case?
Aris Kemper
@ariskemper
Hi
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.
Milan Willems
@Milanw2
Hello! I'm getting an error in my MEAN stack application. "req.query is not a function". Any ideas? Thanks in advance!
Aris Kemper
@ariskemper
How do you use node-mssql, if you have mean stack app?
Milan Willems
@Milanw2
Node is running in the background, so isn't it possible to add mssql?
Aris Kemper
@ariskemper
Mean stack means you are using mongodb
Milan Willems
@Milanw2
I know, but can't I just use mssql to acces my sql server?
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?
Aris Kemper
@ariskemper
Offcourse you could use node-mssql
Check node mssql documentation on how to connect to mssql server
Milan Willems
@Milanw2
Yeah I got that working in a Node console application
But now I'm getting the error: req.query is not a function
Aris Kemper
@ariskemper
This is something with express and sending params to endpoint.
Milan Willems
@Milanw2
Any idea how I can fix this?
Aris Kemper
@ariskemper
Debug your code
I cant give you direct answer
Milan Willems
@Milanw2
Do you know a tutorial I can follow for a new project? Not necessarily a MEAN stack application
I just need to build an Angular 2 app with data from an SQL server
Milan Willems
@Milanw2
router.get('/posts', (req, res) => {
conn.connect(function (err) {
if (err) {
console.log("connection error -->" +err);
return;
}
req.querySELECT 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?
crdil
@crdil
Hello. I'm trying to read queries from a file and run them, but I can't make it work. I'm reading the file with fs.readFile and utf8 into a buffer which I then try to run as query. Is this the wrong approach?
Sotirios Mantziaris
@mantzas
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.
Ali Shaikh
@AliShaikh94
Hi, anyone here?
Selçuk GÜRAL
@selcukgural
hi, how can run query synchronous?
David Gasperoni
@mcdado
Is there a way to increase the connection pool?
dmanhaus
@dmanhaus
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.