I am developing an app that has to read data from SQLSERVER.
After much reading and testing, I decided to use mssql.
"mssql": "*" in my package.json
npm install
and as an example:
*var sql = require ('mssql'); *
*var database = {user = 'youruser', password = 'yourpass', server =
'localhost', database= 'yourdatabasename' port = 1433};*
*var connection = new sql.Connection (database, function (err) {*
*var request = new sql.Request (connection); *
*request.query ('SELECT * FROM your_view', function (err, rsDatosClientes)
{*
*rsDatosClientes; *
*res.json (rsDatosClientes); *
*}); *
*});*
It work for me.
Good Luck!
[email protected]
2014-04-18 18:44 GMT-03:00 Bruno Jouhier <[email protected]>:
> Thanks Ben,
>
> I took a look at it before asking and I was wondering how people can use
> it to stream the rows returned by very large queries. The callback API is
> unhelpful for this and I did not see any pause/resume API to control the
> flow of row events. Tedious does not seem to hande this either (but I only
> took a quick look).
>
> The mysql driver gave me the right API. For oracle, I had to extend the
> driver with a reader API because the existing API was too simplistic. I was
> hoping to get this out of the box from mssql drivers but it looks like I'll
> have to implement it.
>
> Bruno
>
> On Friday, April 18, 2014 10:19:30 PM UTC+2, Ben Noordhuis wrote:
>
>> On Fri, Apr 18, 2014 at 8:24 PM, Bruno Jouhier <[email protected]>
>> wrote:
>> > Just looked at the official driver project
>> > (https://github.com/Azure/node-sqlserver) and was very disappointed to
>> see
>> > that it has not been updated for more than 1 year.
>> >
>> > Tedious (https://github.com/pekim/tedious) seems to be the only really
>> > active project. Is this the right?
>> > Anyone willing to share his/her experience with mssql drivers?
>> >
>> > Bruno
>>
>> As a datum point: all the people I know that use iisnode, also use
>> msnodesql a.k.a. node-sqlserver. That's a sample size of ~10 so make
>> of it what you will.
>>
>> And yeah, the last commit was nine months ago. I'm not sure if that
>> means it's unmaintained or that everything just works but the open
>> issue count suggests it's the former.
>>
> --
> --
> Job Board: http://jobs.nodejs.org/
> Posting guidelines:
> https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
> You received this message because you are subscribed to the Google
> Groups "nodejs" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]
> For more options, visit this group at
> http://groups.google.com/group/nodejs?hl=en?hl=en
>
> ---
> You received this message because you are subscribed to the Google Groups
> "nodejs" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
--
Job Board: http://jobs.nodejs.org/
Posting guidelines:
https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
You received this message because you are subscribed to the Google
Groups "nodejs" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nodejs?hl=en?hl=en
---
You received this message because you are subscribed to the Google Groups
"nodejs" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
