after reconnecting to SQL server I got this error message:
TCP Provider: Semaphore Timeout Period Expired
and after
EUniError: Communication Link Failure. Connection is not establised.
How do I reconnect to database without restarting the application?
My code is:
Code: Select all
procedure TDM.mscConnectionLost(Sender: TObject; Component: TComponent;
ConnLostCause: TConnLostCause; var RetryMode: TRetryMode);
begin
RetryMode := rmReconnectExecute;
end;
AllowExpicitConnect is True
KeepDesignConnected is True
other boolean options are False
I am using UniDac 6.0.2 on Delphi XE7
Operation System: Windows 8.1 (64 bit)
SQL Server: Microsoft SQL Server Standard Edition (64-bit) 9.00.5000.00