[image] Sometimes, the Node-RED function in MSSQL shows the error "ConnectionError: Connection is closed." and stops working at that moment. It then resumes processing with the next task, skipping the one where the error occurred.

Which mssql package are you using? (Look at installed nodes on palette manager)

As a maintainer of the well supported and feature rich node-red-contrib-mssql-plus I would recommend you use that over this unknown new node.

You can. You have 2 choices Manual installation (no need to alter flows) Stop node-red Open terminal Run npm remove node-red-contrib-mssql-yuzhi Run npm install node-red-contrib-mssql-plus Start node-red Via node-red palette manager Remove all mssql nodes from the flow (including config nodes)…

[image] Steve-Mcl: Run red-contrib-mssql-plus Should that be Run npm install node-red-contrib-mssql-plus

Thanks. Never a good idea to post from phone. Updated.

Hi, I install new mssql plus already. You can recommend to use mssql? I am getting the error as shown in the picture. [image] [image]

Add a debug node to the end of the function node and show me what it is outputting. Also, select those three nodes and export (ctrl+e) the flow & paste it into a reply.

I was able to connect to MSSQL, but after connecting and leaving it running for a while, the connection is closed, as shown in the image. [image] [ { "id": "f93acf9b13cc7c11", "type": "http in", "z": "bbfe1ed3bbfa638d", "name": "", "url": "/api/Wastewat…

Node-RED

Node-RED Forum

ConnectionError: Connection is closed

General

Colin 26 August 2024 16:54 7

Should that be
Run npm install node-red-contrib-mssql-plus

Topic		Replies	Views
Node-red-contrib-mssql / Connection is closed General	2	1367	14 October 2021
Can't receive error from node Node-red-contrib-mssql-plus General	11	1750	25 May 2020
MSSQL ERROR tempo obligation General	4	36	8 July 2025
Catch MSSQL node error General	5	2627	25 May 2020
[SOLVED] Node-red-contrib-mssql-plus General	6	3912	27 September 2019

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

ConnectionError: Connection is closed

Related topics