Connecting to a remote Microsoft SQL server from Node.js

Question

I was wondering if anyone was aware of a way to connect to a Microsoft SQL database from Node.js. I'm aware of the MySQL drivers, but I have data that I need to pull from a MS SQL database and would rather pull directly from Node.js rather than hack a PHP script of some sort in place.

Were you finally able to accomplish this without building the proxy or using ActiveX? — lo5
– lo5, Commented Feb 18, 2011 at 20:04
I'm kind of glad I just came across this because I was wondering if anybody would be interested in my node.js-mssql project. It's highly rudimentary at the moment, but I'll be doing another big push later this week with more functionality :) github.com/orenmazor/node-tds — Oren Mazor
– Oren Mazor, Commented Feb 28, 2011 at 15:19
A pure javascript solution provides the node.js module tds4node. GitHub link: tds — ttghr
– ttghr, Commented Apr 26, 2013 at 9:14

Community · Accepted Answer · 2017-05-23 11:46:14Z

10

Check out a new option:

https://github.com/orenmazor/node-tds

(from Node.js and Microsoft SQL Server)

edited May 23, 2017 at 11:46

CommunityBot

11 silver badge

answered Mar 2, 2011 at 1:52

Cade Roux

90.1k42 gold badges186 silver badges268 bronze badges

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

1 Comment

Factor Mystic Over a year ago

The node-tds project description now reads *EXPERIMENTAL and currently ABANDONED*

Community · Accepted Answer · 2017-05-23 12:32:00Z

8

I suspect you'll have to wrap your SQL Server with a JSON outputting web-service. On the positive side, it should be relatively easy to do.

Be nice if the JavaScript engine in node.js could do this: (from How to connect to SQL Server database from JavaScript in the browser?):

var connection = new ActiveXObject("ADODB.Connection") ;

var connectionstring="Data Source=<server>;Initial Catalog=<catalog>;User ID=<user>;Password=<password>;Provider=SQLOLEDB";

connection.Open(connectionstring);
var rs = new ActiveXObject("ADODB.Recordset");

rs.Open("SELECT * FROM table", connection);
rs.MoveFirst
while(!rs.eof)
{
   document.write(rs.fields(1));
   rs.movenext;
}

rs.close;
connection.close;

edited May 23, 2017 at 12:32

CommunityBot

11 silver badge

answered Jan 18, 2011 at 20:51

Cade Roux

90.1k42 gold badges186 silver badges268 bronze badges

2 Comments

Christiaan Westerbeek Over a year ago

Should I downvote this answer, because this is not the best answer anymore in 2014? I'm not sure if downvoting an obsolete answer is considered morally permissible. Look here for the what I think should be used today: stackoverflow.com/questions/5156806/…

treythomas123 Over a year ago

This is no longer a good answer in 2015. Sequelize (if you want ORM) or Tedious are much better options.

Tracker1 · Accepted Answer · 2014-05-15 19:12:06Z

7

I would recommend node-mssql, which is a nice wrapper for other connectors, the default being my previous choice (Tedious) bringing a bit nicer of an interface. This is a JavaScript implimentation, with no compilation requirements, meaning you can work in windows and non-windows environments alike.

Another option, if you don't mind bringing in .Net or Mono with a binary bridge would be to use edge.js. Which can be very nice if you want to leverage .Net libraries in node.js

node-tds is abandoned, node-odbc doesn't work with windows, and the MS node-sqlserver driver doesn't seem to work on non-windows (and has some goofy requirements).

edited May 15, 2014 at 19:12

answered Dec 4, 2012 at 22:18

Tracker1

19.4k12 gold badges86 silver badges106 bronze badges

Comments

Doug Porter · Accepted Answer · 2011-11-25 15:27:44Z

4

If you are connecting to Mssql from linux you can use node-odbc ( https://github.com/w1nk/node-odbc ) with the freetds odbc driver. I am using this in production and its faster than wrapping a web service.

edited Nov 25, 2011 at 15:27

Doug Porter

7,9274 gold badges42 silver badges56 bronze badges

answered Nov 25, 2011 at 15:17

wankdanker

411 silver badge3 bronze badges

Comments

Sneaky Wombat · Accepted Answer · 2012-12-07 19:05:39Z

2

Another option, from Microsoft even,

http://www.microsoft.com/en-us/download/details.aspx?id=29995

Or a linux sql client driver via odbc:

http://www.microsoft.com/en-us/download/details.aspx?id=28160

edited Dec 7, 2012 at 19:05

answered Aug 8, 2012 at 16:29

Sneaky Wombat

1,8482 gold badges21 silver badges29 bronze badges

2 Comments

Tracker1 Over a year ago

The MS option requires a binary module build, and appears to be windows only.

Sneaky Wombat Over a year ago

there are a lot of ways to do this. the microsoft driver is just one. I actually don't use it though for the same reason, windows only. :( I've just found this today though... microsoft.com/en-us/download/details.aspx?id=28160

treythomas123 · Accepted Answer · 2015-09-24 15:18:24Z

2

New answer for 2015: The ORM package Sequelize now supports MS SQL, using the Tedious driver under the covers.

This is the best way I've found to interact with Microsoft SQL Server.

answered Sep 24, 2015 at 15:18

treythomas123

1,3731 gold badge11 silver badges11 bronze badges

Comments

Soham Biswas · Accepted Answer · 2021-07-27 14:54:39Z

0

I recently encountered this problem, I was trying to connect the MSSQL that is hosted on a remote server. The config that I had to use is-

let config = {
    user: 'user',
    password: 'password',
    server: 'server',
    database: 'database',
    "options":{
        instanceName: 'instanceName',
        "encrypt":true,
        "enableArithAbort":true,
        "trustServerCertificate": true,
       }
};
module.exports=config;

For getting the instance name use SELECT @@servicename in SSMS

answered Jul 27, 2021 at 14:54

Soham Biswas

316 bronze badges

Collectives™ on Stack Overflow

Connecting to a remote Microsoft SQL server from Node.js

7 Answers 7

1 Comment

2 Comments

Comments

Comments

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

1 Comment

2 Comments

Comments

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related