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

**URL:** <https://discourse.nodered.org/t/how-get-or-read-data-from-sql-server-in-node-red/77480>\
**Category:** General\
**Tags:** function-node, node-red-contrib-mssql-plus\
**Created:** [12 April 2023 07:21 UTC](https://discourse.nodered.org/t/how-get-or-read-data-from-sql-server-in-node-red/77480 "2023-04-12T07:21:24Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![riimeister](https://avatars.discourse-cdn.com/v4/letter/r/ac8455/32.png) [@riimeister](https://discourse.nodered.org/u/riimeister)\
**Post date:** [12 April 2023 07:21 UTC](https://discourse.nodered.org/t/how-get-or-read-data-from-sql-server-in-node-red/77480/1 "2023-04-12T07:21:24Z")

</div>

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](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/4/f4f2b1ae94d9189dc9f93c0be02457fcd73b4800.png)

Thanks Before,

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [12 April 2023 07:43 UTC](https://discourse.nodered.org/t/how-get-or-read-data-from-sql-server-in-node-red/77480/2 "2023-04-12T07:43:14Z")

</div>

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

e.g.

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/b/4bc0d2d436b977bb57788a63ded6ffb45a7440f5.png)

SQL Node Setup

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/2/42821953b4cc800f54f45fc0ab7e0cf0095ad98a.png)

---

<div class="post-metadata">

**Author:** ![riimeister](https://avatars.discourse-cdn.com/v4/letter/r/ac8455/32.png) [@riimeister](https://discourse.nodered.org/u/riimeister)\
**Post date:** [12 April 2023 08:02 UTC](https://discourse.nodered.org/t/how-get-or-read-data-from-sql-server-in-node-red/77480/3 "2023-04-12T08:02:01Z")

</div>

I got any problem here.  
I already setup with ur guidance  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/8/f8ecbe7f453eaf50a393a9c3476dddcb95ecf38f.png)

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/7/87ef806d9c62ff3bb31f3fa9a6bece62eae2d242.png)

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [12 April 2023 09:24 UTC](https://discourse.nodered.org/t/how-get-or-read-data-from-sql-server-in-node-red/77480/4 "2023-04-12T09:24:06Z")

</div>

Google is your friend: [sql.connectionpool is not a constructor node-red-contrib-mssql-plus - Google Search](https://www.google.com/search?q=sql.connectionpool+is+not+a+constructor+node-red-contrib-mssql-plus)

1st result: [https://github.com/bestlong/node-red-contrib-mssql-plus/issues/22](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?

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [11 June 2023 09:25 UTC](https://discourse.nodered.org/t/how-get-or-read-data-from-sql-server-in-node-red/77480/5 "2023-06-11T09:25:01Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.