I'm trying to write a REST service with Node.js and Express and I need to connect to a SLQServer 2000 database. I've tried the Microsoft connector but it's not working on linux, according to them:
The Microsoft Driver for Node.JS for SQL Server is currently available as a preview release, and relies on run-time components that are only available on the Microsoft Windows and Windows Azure operating systems.
I've also tried node.js's modules tdm and tedious with no success... Any idea?
Check out tedious again. Version 0.2 fixed compatibility with TDS 7.1 (SQL Server 2000).
Have you tried Edge.js?
npm install mssql
I believe that to be the generally accepted best solution
You can use Espresso Logicto create a REST API and then call that from .NodeJS
Even if its a year old question, thought of answering it as it is the first thing that shows up in google for the question.
There is node-sqlserver maintained by Microsoft. The last commit was made 5 months ago though.
Install with $ npm install msnodesql