I just started using Opto 22 products, and forgive my ignorance, but I have some questions on setting up SQL communication through OptoDataLink.
I have a process that runs, and at the end of it's run I want it to write to a database Date/Timestamp, and Duration of that run. This process runs for ~3 mins, pretty frequently.
I saw on OptoDataLink I can establish it to read from my PAC device at some defined interval. How can I set it up for the PAC controller to simply write to it? How do I format it in such a way that it sends those in it's correct form (date/time stamp, duration as a double?)
Would this be done by keeping duration as a variable, and then somehow writing the date/time of when it writes and then pulling that variable? How does the PAC handle network issues? If the connection is down does the data get lost or is it stored? Would the process continue to run even without a proper connection? How can this be handled in the most reliable way?
Still trying to get a firm grasp of how to use this PAC system, coming from labVIEW it's been a pretty large change. Any help is appreciated!