I have problem sending data from OPC UA to MS SQL database. I have 3 tags that i read from my PLC (seconds, minutes and houre). This works find. But when I try to extract the value and put it into my SQL database, I get ann error; Incorrect syntax near '1'. 1 = The second value that counts every s…

Steve-Mcl 7 June 2022 08:02 4

As you can see from the image, that is NOT valid SQL.

Also, I would strongly recommend using parameters to both simplify this and avoid SQL Injection

Here is a demo I did on another thread: Dashboard and MS SQL database - number and text input nodes - #2 by Steve-Mcl

1 Like

Topic		Replies	Views
Multiple OPCUA Items into SQL Database General	2	354	3 September 2022
Write OPC UA Variables to MySQL General	11	1920	22 May 2020
OPC UA client node error Industrial	4	1534	15 December 2020
Split and Join Data From OPC-UA to MySQL General	3	1233	12 February 2021
OPC UA and Arrays General	2	473	2 July 2021

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.

OPC UA to SQL Problem

Related Topics