No route to host

Nikos Mouat nikm at cyberflunk.com
Sun Dec 5 21:15:27 EST 1999



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




More information about the FreeTDS mailing list