Sign in to follow this  
Followers 0
Guest razorbak71

SQL to PLC to diverter gate?

2 posts in this topic

First, I know nothing about PLC's, but I was wondering is there a way to extract data from a SQL database file, feed that to a PLC is some manner, and then have the PLC trigger a diverter gate based on the value in the table exceeding a certain value, to divert parts to another location. Am I off base, or is there something out there that will allow or help me to do this. Any help would be greatly appreciated.

Share this post


Link to post
Share on other sites
You could probably achieve that though VB(with SQL query language) or a SCADA package, or OPC. In the case of the VB u need a driver for the comm's of the PLC, either right one u self or buy an OPC/ActiveX PLC comms software - ie for Omron PLC's CX-Server OPC or CX-Server Lite (Active X). So yeh, it can be done. Either way u will probably need to do a bit of programming in VB or the SCADA scripting language etc. The PLC can look at a value that comes in and do a compare on it to trigger an event etc....... Sorry, i haven't got any sample code for u.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0