Node for node-red to connect to a Microsoft MS SQL Database
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
Use the Manage Palette > Install option from the menu inside node-red
Alternatively in your Node-RED user directory, typically ~/.node-red, run
npm install node-red-contrib-mssql-plus-box