Connecting Sql Server though Node.js

Question

I want to connect to SqlServer through Node.js.

I have tried many ways and many links but nothing is work properly. I want to connect to SqlServer and fetch some data.

Please can someone suggest some steps and code to connect SqlServer 2008. What is the Driver for Sql-Node.js?

i m using OS windows 7 with 64 bit processor. plz suggest some ans.... — HomeWork
– HomeWork, Commented Jun 18, 2013 at 11:26

Johan Danforth · Accepted Answer · 2014-03-29 14:29:16Z

1

I just did it following this walkthrough at http://tech.pro/tutorial/1848/getting-nodejs--sql-server--azure-to-work-together

He's using the "msnodesql" package at https://www.npmjs.org/package/msnodesql, code at git-hub at https://github.com/WindowsAzure/node-sqlserver, and I've got it running in a node-console app with a simple select-statement:

var mssql = require('msnodesql');

var conn_str = "Driver={SQL Server Native Client 10.0};Server=tcp:xxxxx;Database=yyyy;Uid=zzzz;Pwd=wwww;Connection Timeout=30;";

    mssql.query(conn_str, "select * from testtable", function(err, recordset) {
    if(err){
        console.log("Got error :-( " + err);
        return;
    }

    recordset.forEach(function(record) {
        console.log("name: " + record.Name + " (" + record.ID + ")");

    });
});

answered Mar 29, 2014 at 14:29

Johan Danforth

4,6296 gold badges40 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connecting Sql Server though Node.js

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related