Hi

This will depend on the method the PLC is programmed. You can pull data from
a SQL Server database using many different interfaces

A starting place may be
http://msdn.microsoft.com/library/de...asp?frame=true

In general using the database as a realtime system is not what they are
designed for. You may want to implement an event from a trigger using a COM
object and the sp_OA* procedures or possibly using the existance of a file
as an event (or similar using some form of polling). It may also be possible
to do this with Notification Services
http://msdn.microsoft.com/library/de...asp?frame=true

If using a trigger you should make sure that it is not left waiting for
something to happen as this will extend the duration of your transactions.

John


"Razorbak71" <razorbak71@yahoo.com> wrote in message
news:c4aa35eb.0311061930.1262a64c@posting.google.c om...
> 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.