Working with the WagoAppSQL_MySQL

I am trying to connect the CC100 Wago plc to our SQL server via the app library. Inside the library the function block FbMySql_Login does not have a field for Server Name. Our server has multiple server names on this IP address. How do I construct a login into that specific server name with the specific username and password? Any thoughts if this is capable? If there isn’t a way. Could someone help me construct a node-red connection since I have that option to.

I am using the WagoAppSQL_MySQL, 1.6.2.6

So on your server you have multiple server name (are you talking about URI/URL ?).
Does that name redirect to a server IP:Port ? or is it internal to the SQL system ?

Come to find out I just needed to change the port that was being used. Not a normal setup. and I have to use the IP address directly. Thank you all.

1 Like