Re: freetds is hanging while trying to connect to the offline host

Frediano Ziglio <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
2010/6/17 Eugene Eugene <[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.

Strange, should return after the timeout? Could you post your
connection settings?
Which FreeTDS version are you using ??

freddy77
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds
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.