Subject Interbase connection problems
Author Johannes Pretorius
Good day
-\=0-=0=-0

I have ENDLESS hastles at MULTIPLE clients that we cannot solve. Interbase
keeps on or kicking people of or the program
disconnects ugly. But I cannot seem to trace or fix the problem at all.
There is no sense in any of the log file. AT some point
it even seems asif INTERBASE cannot connect to itself via the triiggers as
it gives the error

Error chicking feed trigger : General SQL error. Unable to complete network
request to host "localhost"
Error writing to the connection.
unknown Win32 error 10054

The above error is from a CLIENT machine

the interbase log file looks as follows at the times of these errors.

//============= SNIP START LOG =============
BLOEM_SVR (Client) Mon Mar 03 11:58:58 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:58:58 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:58:58 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:58:58 2003
REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
Uncommitted work may have been lost

BLOEM_SVR (Client) Mon Mar 03 11:58:58 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:24 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:24 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:24 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:24 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:24 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:24 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:24 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:24 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:36 2003
C:\Program Files\InterBase Corp\InterBase\bin\ibserver.exe:
terminated abnormally (-1)


BLOEM_SVR (Client) Mon Mar 03 11:59:36 2003
Guardian starting: C:\Program Files\InterBase
Corp\InterBase\bin\ibserver.exe


BLOEM_SVR (Client) Mon Mar 03 11:59:49 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:49 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:49 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:49 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:54 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:54 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:54 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:54 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:54 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:54 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:54 2003
INET/inet_error: send errno = 10054

BLOEM_SVR (Client) Mon Mar 03 11:59:54 2003
INET/inet_error: send errno = 10054

//================= 8< ===== END LOG END =============================

Can ANYBODY please give me any pointers onto how to solve these problems or
where to start.

Please note this is happening at more than one database. From databases
that is from size : 211 upto 854 MB

also the Intebase version is 5.6

Thanks in Advance

Johannes Pretorius



[Non-text portions of this message have been removed]