freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: Brian Bruns <camber AT umcc.ais.org>
- To: TDS Development Group <freetds AT franklin.oit.unc.edu>
- Subject: Re: No route to host
- Date: Sun, 5 Dec 1999 21:42:00 -0500 (EST)
Basically this means that connect() is returning EHOSTUNREACH, which
according to my man pages isn't a valid return. They are always so out of
date anyway.
The only thing that I can see off hand would be an occasional DNS lookup
failure. Have you had any problems with DNS? Try replacing the host name
with an IP address and see if that helps at all. That'll at least give us
more information to go on.
Brian
On Sun, 5 Dec 1999, Nikos Mouat wrote:
>
> Hi,
> I'm using FreeTDS to access a MSSQL 7.0 server. The program runs every
> hour, and frequently (about 5 times a day) I get an error something like
>
> No route to host.
> DB-Error: could not connect
>
> or something like that. It is certainly a 'no route to host' related
> message. The machine that this is running on is on the same subnet as the
> mssql 7 server.. and if I retry immediately, then it frequently, but not
> always suceeds.
>
> Here is the login source. dbopen is returning null when this happens.
>
> {
> LOGINREC *login;
>
> dbinit();
> login = dblogin();
> DBSETLPWD(login,"<password>");
> DBSETLUSER(login,"<user>");
> DBSETLAPP(login,"<database>");
> DBSETLHOST(login,"<dbserver>.<domain>.com");
> *dbproc = dbopen(login, "<name from interfaces file>");
> if (*dbproc == NULL)
> return false;
> dbloginfree(login);
> return true;
> }
>
> interfaces has:
>
> <name from interfaces file>
> query tcp ether <dbserver>.<domain>.com 1433
> master tcp ether <dbserver>.<domain>.com 1433
> console tcp ether <dbserver>.<domain>.com 1433
>
>
> is this is a bug in the library? or more likely an error in the way I'm
> doing things.. it's a very recent version of the code, maybe three weeks
> old.
>
> nm
>
>
> ---
> You are currently subscribed to freetds as: camber AT ais.org
> To unsubscribe, forward this message to $subst('Email.Unsub')
>
>
-
No route to host,
Nikos Mouat, 12/05/1999
- <Possible follow-up(s)>
- Re: No route to host, Brian Bruns, 12/05/1999
- Re: No route to host, Adam Haberlach, 12/06/1999
- Re: No route to host, richard, 12/06/1999
- Re: No route to host, Mark Schaal, 12/06/1999
- Re: No route to host, Adam Haberlach, 12/06/1999
- Re: No route to host, richard, 12/06/1999
- Re: No route to host, Brian Bruns, 12/06/1999
- Re: No route to host, Nikos Mouat, 12/07/1999
- Re: No route to host, Allyn Craig, 12/07/1999
- Re: No route to host, Brian Bruns, 12/07/1999
- Re: No route to host, Nikos Mouat, 12/09/1999
Archive powered by MHonArc 2.6.24.