How Get or Read data from SQL Server in node red?

General
,
1

Hi everyone,

How to read or pull data from sql server on node red? If I send data I understand, but if I pull data from a table on the SQL server database, I have never done that.

sample data I want to read or pull

image

Thanks Before,

2

Simply put your query into node-red-contrib-mssql-plus and send a msg to it to execute the query.

e.g.

image

SQL Node Setup

image
image519×1091 24.9 KB

3

I got any problem here.
I already setup with ur guidance
image

image
image766×199 6.03 KB

4

Google is your friend: sql.connectionpool is not a constructor node-red-contrib-mssql-plus - Google Search

1st result: https://github.com/bestlong/node-red-contrib-mssql-plus/issues/22

  • What version is your node-red and NodeJS?
  • What version of the mssql-plus node is installed into node-red?
  • What settings have you entered in the SQL connection?
  • Do you have other MSSQL nodes installed?