How to setup MSSQL connection fields from function node / outside the node?

General
1

Basically I want to access SQL node each fields from dashboard to enter data. Therefore is it possible to access those fields from outside the SQL node ?

eg: accessing name from function node like "msg.name".

any help would be really appreciated :slight_smile:

please see the image
sgfsgs

2

It is not possible to dynamically set a connection from dashboard or messages. The connection is a shared config object setup at design time.

However, if you are using node-red-contrib-mssql-plus you can use environment variables for those fields.

3

Oh okay. I will try with that. Thanks for the reply as well as the solution.

-Jude

4

note - environment variables are only evaluated at deploy time - so you have to restart Node-RED to reload any changes.

1 Like
5

okay thank you.

6

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