Welcome to the Forums!
I don’t have a solution for OptoDataLink inserting the same data over and over until the network comes back up… Sorry.
Just wanted to let you know of a method that I have been using for eleventy eight years with no problems.
You can read about it here; http://www.opto22.com/community/showthread.php?t=380
I am pointing it out because data can only be inserted when the controller calls the script. If the network is down between the controller and the computer, no data will be inserted.
(When you look at that page, keep in mind you just need the first few steps, just enough to put the data into SQL, you don’t need all the graph stuff).
Honestly, it is not for everyone, but if [I]you [/I]want really fine/total control, it might be the solution.
Also, I do not have any experience with SQL, since I am a bit of a Linux hack, it’s MySQL for me. I am just guessing that the same insert method used in MySQL will work in SQL.
Hope that this is helpful. There is usually many different ways to tackle things with Opto, just a matter of picking the one you like.