Access to SQLServer with Node.js on Linux

Question

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?

what about mono ? I mean - try getting node work on mono, for example. cause afaik - mono can talk to MS SQL — YS., Aug 08 '12 at 10:52
possible duplicate of [Connecting to a remote Microsoft SQL server from Node.js](http://stackoverflow.com/questions/4728385/connecting-to-a-remote-microsoft-sql-server-from-node-js) — podiluska, Aug 08 '12 at 12:42
question you're quoting presents solutions that didn't work for me, as explained in the question — Kalimaha, Aug 08 '12 at 13:16
Can you provide more detail on why, for instance, you could not use tedious? — Rob Raisch, Aug 08 '12 at 16:44

score 1 · Answer 1 · answered Jun 11 '14 at 22:54

1

Check out tedious again. Version 0.2 fixed compatibility with TDS 7.1 (SQL Server 2000).

answered Jun 11 '14 at 22:54

Ben

3,255
1
26
32

I use tedious on Ubuntu to connect SQL-SERVER on other server, it works great. – Muath Jul 20 '14 at 18:20

score 0 · Answer 2 · answered Jun 20 '14 at 20:47

0

Have you tried Edge.js?

Leverage SQL Server with node.js.

answered Jun 20 '14 at 20:47

Virat Singh

61
4

score 0 · Answer 3 · answered Jun 28 '14 at 14:41

0

npm install mssql

I believe that to be the generally accepted best solution

answered Jun 28 '14 at 14:41

akc42

4,893
5
41
60

score 0 · Answer 4 · answered Sep 19 '14 at 05:43

0

You can use Espresso Logicto create a REST API and then call that from .NodeJS

answered Sep 19 '14 at 05:43

sqlrest

1

score -1 · Answer 5 · edited Jun 20 '20 at 09:12

-1

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 .

edited Jun 20 '20 at 09:12

Community

1
1

answered Oct 26 '13 at 18:07

meadhikari

971
3
13
27

3

Ubuntu is not supported. It's just for windows. – matteofigus Dec 02 '13 at 12:00
2

The question explicitly asks about linux support and your answer is a Windows only solution – Joseph DeCarlo May 15 '14 at 12:19

Access to SQLServer with Node.js on Linux

5 Answers5