Mssql not sending data to database using mustache format

General
, ,
4

That node is over 7 years old, uses old libraries (with CVE issues) and has a number of known bugs and last, but not least, does not have the additional features that make mssql-plus the best SQL node in the catalog.

I suggest you remove that and add the newer/better one and use parameters.

You have 2 choices to acheive that ^

  1. remove all traces of mssql from your flows
  2. remove node-red-contrib-mssql via palette manager
  3. install node-red-contrib-mssql-plus via palette manager
  4. restart node-red
  5. add the SQL nodes back into your flows

OR

  1. stop node-red
  2. run npm remove node-red-contrib-mssql (in a terminal, in ~/.node-red)
  3. run npm install node-red-contrib-mssql-plus (in a terminal, in ~/.node-red)
  4. start node-red

The 2nd version is my recommendation but not everyone is comfortable with command line.