AnsweredAssumed Answered

Open Remote File After Momentary Interruption

Question asked by crmon123 on Oct 25, 2018

Hey All!

Looking for a possible solution. I have a database that has External Data Sources. Occasionally, one of the External Data Sources becomes disconnected momentarily (network fluctuation).


When this happens, is there a way to script in a reconnection? I thought maybe using a loop to make multiple attempts before exiting the script and use the OPEN DB script step, but once an already opened files becomes Disconnected, it seems that the OPEN DB doesn't work without manual intervention... which i need to avoid.


Thanks in advance for giving this some thought. I appreciate it.