At 02:16 AM 21/06/2009, delphi_xpart wrote:

>Hello all,
>
>I am developing a client application that connects the Remote server using Zebedee. The port is localhost/3051. The application cennects well but after some time it shows an error "connection lost with localhost".

You need to look at the SSH timeout settings for both host and client...

>I hv put OnDisconnect event in FIBPlus Database Connection but that message is not displayed while the connection is being termnated.

Delphi OnConnect/OnDisconnect events are related to attach/detach requests made by the client application. Your client application won't know it is disconnected if it didn't call Disconnect.

>If I use IP address without Zebedee, the application takes long time to connect to the Database.

1 MB bandwidth is unrealistically slow for a TCP/IP connection, even without the copious round-tripping you get from Delphi applications.

>For Data retrieval I am using Stored procedures.

That might be useful or not useful on a slow connection, depending on how the application is retrieving the dataset. If it is retrieving the SP output one row at a time there is a benefit. If it is waiting for a complete set, or a subset of more than a few rows, then the likelihood of losing your slow connection altogether during the wait time is fairly strong. If you have written the kind of application that can't even do anything without having all datasets open then you have to redesign it to open datasets on an as-required basis and to retrieve as few rows as possible.

>Why this is happening? can any one help?
>
>The remote Server: Windows 2003 server with 4 MB RAM
>Firebird Server: Super Server 2.0
>Bandwidth: 1 MB in both ends (Server and clients)

Look in the server's firebird.log to see what network timeout messages might be there. Forget about trying to use TCP/IP as the primary network transport on a 1 MB connection. Grab the SSH documentation for your server and try to test some more realistic timeout settings for the SSH tunnel.

If you want to get some tips about using Zebedee/SSH and/or Delphi with Firebird, post a suitably informative question in Firebird-tools.

^ heLen ^