Jump to content

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...