Can't reconnect to MS SQL Server

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Scoundrel
Posts: 5
Joined: Thu 08 Nov 2007 12:00

Can't reconnect to MS SQL Server

Post by Scoundrel » Wed 08 Apr 2015 05:55

Hi,

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;
LocalFailover is True
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

azyk
Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Can't reconnect to MS SQL Server

Post by azyk » Wed 15 Apr 2015 11:46

We can't reproduce the described problem on the latest UniDAC version. Please update UniDAC to 6.1.3 and let us know if the problem is still reproduced. You can update UniDAC at http://www.devart.com/unidac/download.html .

Post Reply