Using Node.js to connect to Microsoft SQL Server 2008 (MSSQL) database

sql-server node.js sql-server-2008 node-mssql tedious
paperclip picture paperclip · Sep 28, 2011 · Viewed 11.5k times · Source

Possible Duplicate:
Connecting to a remote Microsoft SQL server from Node.js

I'm looking for an up-to-date explanation of how to connect to a MS SQL Sever 2008 using Node.js (v0.5.7)

I have tried both Node.js projects on GitHub here:

https://github.com/vivina/node-mssql

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

node-tds is an abandoned project and node-mssql appears to be incomplete or at least the code-base seems to be out-of-date with the most recent version of Node.js

Has anyone actually got Node.js to connect to and query a Microsoft SQL Server 2008?

I would love to see some configuration details (versions, addons etc.) and code samples.

Thanks,

P.

Out of date answers on SO: Node.js and Microsoft SQL Server, Connecting to a remote Microsoft SQL server from Node.js

Answer

Fosco picture Fosco · Dec 14, 2011

Just today I released a new module, for windows only, allowing native and asynchronous use of MSSQL. It's called TSQLFTW, and currently supports connecting and querying the database. It returns results in JSON.

Check out the Github here: https://github.com/gfosco/tsqlftw

Hacker News submission/comments: http://news.ycombinator.com/item?id=3353389

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