# Node-red-contib-mssql-plus

**URL:** https://discourse.nodered.org/t/node-red-contib-mssql-plus/89042
**Category:** General
**Tags:** database, node-red-contrib-mssql-plus
**Created:** [28 June 2024 11:36 UTC](https://discourse.nodered.org/t/node-red-contib-mssql-plus/89042 "2024-06-28T11:36:10Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![jctamy](https://avatars.discourse-cdn.com/v4/letter/j/8c91f0/32.png) [@jctamy](https://discourse.nodered.org/u/jctamy)
#### Post date: [28 June 2024 11:36 UTC](https://discourse.nodered.org/t/node-red-contib-mssql-plus/89042/1 "2024-06-28T11:36:10Z")

</div>

Hi folks, I was experimentating some problems with palette node-red-contrib-mssql. Then I saw that any update was made in 7 years ago. So now I have upgrade to plus mssql palette, and shows me this error:

Insert query:

```auto
INSERT INTO [acabados].[dbo].[contadores_agua] (m3_Parciales_Pozo2,m3_Totales_Pozo2,m3_Parciales_Pozo3,m3_Totales_Pozo3,m3_Parciales_Pozo4,m3_Totales_Pozo4,m3_Parciales_Pozo5,m3_Totales_Pozo5,m3_Parciales_Pozo6,m3_Totales_Pozo6,m3_Parciales_Permo1,m3_Totales_Permo1,m3_Parciales_Permo2,m3_Totales_Permo2) VALUES (0,0,0,0,0,0,0,243268,0,242949,0,127255,0,218259)

```

Degug of mssql-plus node

```auto
{"message":"Cannot read properties of null (reading 'execSql')","details":"Cannot read properties of null (reading 'execSql')","name":"TypeError"}

```

What I'm doing wrong?

Best Regards,  
Juan Carlos

---

<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: [28 June 2024 14:21 UTC](https://discourse.nodered.org/t/node-red-contib-mssql-plus/89042/2 "2024-06-28T14:21:41Z")

</div>

Share a minimal flow that reproduces the issue. Use standard core node-red nodes only (use inject/function/change node to simulate input data) and the MSSQL-PLUS node.

Select the nodes of interest, press `CTRL-E` then copy to clipboard and paste into a code block in the forum response.

Also, share a screenshot of the MSSQL node and the MSSQL config node.

---

<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: [26 September 2024 14:22 UTC](https://discourse.nodered.org/t/node-red-contib-mssql-plus/89042/3 "2024-09-26T14:22:07Z")

</div>

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