- This topic has 2 replies, 2 voices, and was last updated 14 years, 1 month ago by .
Could anyone please tell me how we can re-eastablish a connection without restarting the thread (or the process)?
We are on CL 5.5MB and are connecting b/w Oracle Server (Source) and MS SQL server (Destination).
Recently, the network connection b/w the two sites (servers located in two different sites) gets disconnected for few minutes. The probem is that this happens at around 4:00 AM and the thread throws “[Microsoft][ODBC SQL Server Driver]Communication link failure” error for all the messages till it is restarted. It does not reconnect (by itself) once the netwrok connection is re-eastablished.
Does anyone know a way to re-eastablish the connection once the n/w connection is re-eastablished?
- The forum ‘Cloverleaf’ is closed to new topics and replies.