56flyboy Posted June 24, 2014 Report Share Posted June 24, 2014 Is there any automated way to get data from a database such as SQL into a V350 in an automated way?It would be nice to go from an external database into a Data Table. Anyone with experience in this area? Quote Link to comment Share on other sites More sharing options...
linxchas Posted June 25, 2014 Report Share Posted June 25, 2014 You need to write application and modify your PLC project. There is many ways to do that. The best way depends on your specific requirements. I have similar server application that distributes data from SQL across hundreds of V-570 PLC's: each controller connects to the server on port 20257 once per 5 min, provide his ID and receives relevant data. Quote Link to comment Share on other sites More sharing options...
56flyboy Posted August 8, 2014 Author Report Share Posted August 8, 2014 You need to write application and modify your PLC project. There is many ways to do that. The best way depends on your specific requirements. I have similar server application that distributes data from SQL across hundreds of V-570 PLC's: each controller connects to the server on port 20257 once per 5 min, provide his ID and receives relevant data. That sounds like what I am trying to do. Can you give me more details about how you did this? Does the database send data to the PLC via PCOM? Do you have an example you can send me? - Thanks! Quote Link to comment Share on other sites More sharing options...
linxchas Posted August 11, 2014 Report Share Posted August 11, 2014 Here is tiny server application (C#2008) which is stays on public IP, connected to SQL and distributes data between hundreds of PLC'c: https://dl.dropboxusercontent.com/u/61256880/Unitronics/VL_Connect.7z This link to Visilogic subroutine that actually executes PLC client function: https://dl.dropboxusercontent.com/u/61256880/Unitronics/GetPortNumber.7z Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.