freetds is hanging while trying to connect to the offline host

Eugene Eugene <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
Hi,
I have got many SQL Server hosts in freetds.conf and usually database
connection check works fine.
But sometimes all SQL Server databases in freetds.conf are giving
timeout messages. It seems that it is because a server is down
resulting in freetds is hanging while trying to connect to the offline
host. Even though our script cycles through all the database servers,
it relies on freetds which cannot go past the offline host. The
resolution is to remove the host entries in freetds.conf . Setting
different timeouts within freetds hasn’t helped.
Any ideas how to fix this hanging problem?

Thank you and best regards, Eugene.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.