Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

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

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

Problem

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

Problem courtesy of: paperclip

Solution

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

Solution courtesy of: Fosco

Discussion

View additional discussion.



This post first appeared on Node.js Recipes, please read the originial post: here

Share the post

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

×

Subscribe to Node.js Recipes

Get updates delivered right to your inbox!

Thank you for your subscription

×