node-red-contrib-mssql-plus-box 0.1.4

Node for node-red to connect to a Microsoft MS SQL Database

npm install node-red-contrib-mssql-plus-box

node-red-contrib-mssql-plus-box

A Node-RED node for connecting to Microsoft MS SQL Databases.

Importantly, this package comes with pre-built linux drivers for communicating with the Azure & MS SQL services (using TDS protocal), removing the need to set-up environment level MSSQL (or similar) drivers.

Added disconnect of database on each message input

Install

Easiest

Use the Manage Palette > Install option from the menu inside node-red

Harder

Alternatively in your Node-RED user directory, typically ~/.node-red, run

npm install node-red-contrib-mssql-plus-box

Other

This node based on node-red-contrib-mssql-plus. Thanks to Redconnect.io.