I’m using a SNAP-PAC R1 to run a piece of production test equipment. I need to be able to transfer test data and results from the controller to a SQL database. I’m using OptoDataLink (9.4e) running off a local server at our manufacturing plant to do the transfer. Due to some IT limitations we have relatively frequent network outages between the controller and server. The connection between the server and SQL database remains stable. I’ve handled this on the controller side by buffering data to an SD card when there’s a connection problem. Unfortunately, OptoDataLink will send duplicate rows of the last data transfer to the database until the connection to the controller is reestablished. The result is a messy data set with a lot of duplicates. I contacted Opto22 Product Support and was told that OptoDataLink is working as intended. Ideally if the connection dropped the last data transfer would be written to the database only once.
Has anyone else run into this? Is there a workaround? Are there any other ways people are sending data from a controller to a SQL database that I may be missing?
Attached is a screenshot of my OptoDataLink settings.