Connecting to a remote Microsoft SQL server from Node.js

node.js node-mssql
A Wizard Did It picture A Wizard Did It · Jan 18, 2011 · Viewed 22.7k times · Source

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.

Answer

Cade Roux picture Cade Roux · Mar 2, 2011

Check out a new option:

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

(from Node.js and Microsoft SQL Server)

Related questions

Node.js MSSQL tedius ConnectionError: Failed to connect to localhost:1433 - connect ECONNREFUSED

I am trying to connect to MSSQL 2012 using NodeJS with the mssql connection interface. When attempting to connect I get the following error: { [ConnectionError: Failed to connect to localhost:1433 - connect ECONNREFUSED] name: 'ConnectionError', message: 'Failed to conncet to localhost:1433 …

Read More
Node.js and Microsoft SQL Server

Is there any way I can get my Node.js app to communicate with Microsoft SQL? I haven't seen any MS SQL drivers out there in the wild? I'm putting a very simple app together and need to be able …

Read More
How can I use a single mssql connection pool across several routes in an Express 4 web application?

I want to use node-mssql as a MSSQL database connector in a Node JS Express 4 web application. Route handler logic is handled in separate files. How do I create a single/global connection pool and use it across several files …

Read More