search

bestlong / node-red-contrib-mssql-plus

A Node-RED node to read and write to Microsoft MS SQL Databases
MIT License
31 stars 18 forks source link

Examples of using a connection node? Cannot even find the node in the palette #50

Closed werkstrom closed 3 years ago

werkstrom commented 3 years ago

Sorry for perhaps being a noob question, but how can I setup a common connection that opens in the beginning of a flow. Will be used for a lot of operations/queries and then closed at the end of the flow. I cannot find an example and honestly don't know how to implement it. I cannot even find the CN-node in my palette (it shows up as installed but I cannot find it to drag it into my flow). Have tried in Azure web app, Azure Ubuntu VM and on my Home Assistant with the same result :-( Can I be missing some prerequisite chrome_ksOmyon3GV chrome_8sRrMaIINA

?

Steve-Mcl commented 3 years ago

how can I setup a common connection

You add an MSSQL node to the flow, open it, then setup a connection.

image

Then when you add more MSSQL nodes to the editor, that common config is available to all other MSSQL nodes.

This is not unique to the MSSQL node (this is how node-red does shared config nodes)

If you have further questions about usage, the best place to start is the node-red fourm (in fact most of your questions will have been asked and answered - use the forum search before posting)