delphi_xpart wrote:

> after some time it shows an error "connection lost with localhost".

I had this problem many times. Most probably, the connection gets
terminated somewhere between client and server. One of those computers
is probably behind NAT layer, and the firewall cuts down tunneled (i.e.
zebedee) connections because it cannot see the real TCP packets that
would keep it alive. Also, some gateways are simply configured to kill
any long-running TCP connection regardless of the state (Some versions
of SuSE Linux had a "nice" default firewall setting for that)

> message is not displayed while the connection is being termnated.

This message is only displayed with client or server terminate the
connection. However, when some network node in-between decides the that
"session" is over, it simply dumps it without noticing either side. If
you run Firebird 2.1, check the monitoring tables on the server. Most
probably, it will look like the connection is still alive.

> Why this is happening? can any one help?

Run traceroute command to see all the nodes between client and the
server and talk to the network admins responsible for them to allow
zebedee connections (port 11965) to stay alive indefinitely.

--
Milan Babuskov
http://www.flamerobin.org
http://www.guacosoft.com