Hi everyone, can someone guide me how do I send the data from my plc to my SSMS database? I’ve already have all connected but I only can send the data through my ‘Online Simulation’ in easybuilder.
Thanks!
Hi @Rafaelk21,
Is the database hosted locally (on the same computer you are using for development) or cloud based?
Yes, same computer that I’m working with
Hi @Rafaelk21,
Thanks for the quick reply. Just for our reference, before you download the application you change the loopback IP to the PC’s actual IP, correct?
No, im using 127.0.0.1 as IP from SSMS, is that the question?
Sorry for any confusion, but yes, that was the question. Before you download the project, you should change the IP used within your project from the loopback IP of 127.0.0.1 to the PC’s actual IP, then the HMI should be able to reach the database.
Oh just to be clear, I need to use my pc IP in SSMS is that it?
and where I change? In SSMS or in database setting in easybuild?
Yes, that’s correct!
Ok, one more question, the port number I leave as 1433?
Yes, that is the default port for MS SQL.
Hi,
Just to say, that is working. Thank you!!
But now I have a question about mqtt, perhaps you can help me without creating a new topic and spam the forum.
I’m using mosquitto as a broker, the tutorial on youtube works with mosquitto too?
Hi @Rafaelk21,
You can use a Mosquitto MQTT server (as confirmed in the user manual below). However, we cannot confirm whether the setup process is identical to the one shown in the video.
Hi,
Working!! Thank you for the support
Hi,
One more doubt about the DB, its working fine, but how do customer can insert which type of item he’s working with and send to the DB? For now I only can read the values from PLC which is working good.
Please refer to the video below:
Hi,
Is it possible when I chance a value from one tag in plc, automatic changes a window in easybuilder pro?
Hi @Rafaelk21,
This video demonstrates how to change the current window based on a value within the PLC.
Hi,
Done!
