Terry


Nice to see you're still around.

>EDB will NOT send a ping if you already have something running that uses the
>communication layer to the server. Try creating an event for the
>OnRemoteTimeout of your remote session and set StayConnected:=True; in the
>event code. This will prevent it from timing out during a really long
>query.

Interesting and useful.

Roy Lambert

Hi Adam,

> This is a really useful tip, particularly if you are running slow
> PROCEDURES (like transferring files up to a server).

I don't believe that transferring files to the server should be an issue as
it's active communication between your app and the server.


> In that case (i.e. remote server crashing part-way through a query /
> procedure) would the above method result in an infinite connection or does
> some other event then get triggered?

If the server crashes part way through the process, you will get a lost
connection error from EDB.

---------------------------------------
Terry Swiers
Millennium Software, Inc.
http://www.1000years.com
http://www.atrex.com
---------------------------------------

Hi Adam,

> This is a really useful tip, particularly if you are running slow
> PROCEDURES (like transferring files up to a server).

I don't believe that transferring files to the server should be an issue as
it's active communication between your app and the server.

The situation that forced me to really look hard into it was restructuring
of large tables on a slow server.  I may be incorrect in my assumption, but
it appears that EDB has to wait for the OS to make the table "old" copies
and doesn't send status or progress back to the app while this is occurring.
This was causing my app to fail during some large database updates.


> In that case (i.e. remote server crashing part-way through a query /
> procedure) would the above method result in an infinite connection or does
> some other event then get triggered?

If the server crashes part way through the process, you will get a lost
connection error from EDB.

---------------------------------------
Terry Swiers
Millennium Software, Inc.
http://www.1000years.com
http://www.atrex.com
---------------------------------------

Hi Roy,

> Nice to see you're still around.

Definitely still here.  Just been so busy with my own stuff that I haven't
had much time to spend here.


> Interesting and useful.

Glad I could help.   I'm usually boring and useless.  

---------------------------------------
Terry Swiers
Millennium Software, Inc.
http://www.1000years.com
http://www.atrex.com
---------------------------------------

Terry


>Glad I could help. I'm usually boring and useless.

Can't comment about the boring since we have never actually spoken but useless - no. I use (slightly modified versions of) you applock component. That's great.

Roy