search for: win32oleexcept

...the sqlserver adaptor there is code like @connection.execute(sql) Im proposing that I wrap this in anthoer method, and use something like this ( untested so far): def execute_with_rescue( sql ) reconnect_attempts = 0 retry_count=0 begin @connection.eexecute(sql) rescue Win32OLEException => e # or whatever the class is # send an email so I know its still happening if /Connection failure/.match( e.to_s ) retry_count+=1 retry if retry_count < 2 end # if its still failing, drop the connection and reconnect if...