harryting
Lifetime Supporting Member
I'm a newb in working with RSSQL. So far I went through the steps and everything looks ok (green light) but I just can't seem to get the trigger part working.
Briefly, this is my setup:
I'm trying to log a numerical value (Float) to a MS Access table when a bit in the PLC goes high.
- RSLinx Classic as Control Connector.
- ODBC as Enterprise Connector
- the trigger bit set as "unscheduled"
- Set the transaction trigger to unscheduled and on raise.
now when I run the configuration. Nothing happens. I also tried the default trigger configuration which use "scheduled" event and managed to at least update the database but the value logged were null.
Ya, FactorySQL seems so much easier but I already own this from a prior project. Any pointer would be appreciated.
Briefly, this is my setup:
I'm trying to log a numerical value (Float) to a MS Access table when a bit in the PLC goes high.
- RSLinx Classic as Control Connector.
- ODBC as Enterprise Connector
- the trigger bit set as "unscheduled"
- Set the transaction trigger to unscheduled and on raise.
now when I run the configuration. Nothing happens. I also tried the default trigger configuration which use "scheduled" event and managed to at least update the database but the value logged were null.
Ya, FactorySQL seems so much easier but I already own this from a prior project. Any pointer would be appreciated.