Ping and connectionTimeOut

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
EarlyBird
Posts: 15
Joined: Thu 02 Dec 2010 08:54

Ping and connectionTimeOut

Post by EarlyBird » Tue 01 Oct 2013 09:34

Hi,
how to set connectionTimeout for the Ping method?
I set connectionTimeOut to 5.
But if ping fails it always takes over 45 seconds.
can i change it?

Thanks for help

AndreyZ

Re: Ping and connectionTimeOut

Post by AndreyZ » Tue 01 Oct 2013 14:04

Hello,

The Ping method takes into account the ConnectionTimeout property. Please specify the exact situation when the Ping method waits 45 seconds whilst ConnectionTimeout is set to 5 seconds.

EarlyBird
Posts: 15
Joined: Thu 02 Dec 2010 08:54

Re: Ping and connectionTimeOut

Post by EarlyBird » Tue 01 Oct 2013 18:17

Hello,
I connect from the client to the Server over a network via VPN.
The ConnectionTimeout is set to 5
For a test I close the VPN and then try to Ping to the Server.

AndreyZ

Re: Ping and connectionTimeOut

Post by AndreyZ » Thu 03 Oct 2013 10:12

To work with SQL Server, UniDAC uses the OLEDB or SQL Native Client provider. The value you set in the ConnectionTimeout property, SDAC transfers to the used provider. There is no way for SDAC to influence the exact time the provider waits for respond from the server. We cannot influence the behaviour of the provider.

Post Reply