??
If it is always the same 4th terminal that continues to work it sounds like a
network problem, try checking the server, firebird server log for unexpected
client disconnects.

Could it be that "simple" operations don't cause a problem but this query is
stressing the network?

Andy

dr_bentonquest wrote:

> Network setup:
> One W2K Server, running FB 1.0 server
> Three client applications built with Delphi 7 and IBObjects running
> on W98 terminals, FB 1.0 client install. I¡¦m using IBO¡¦s TDataset-
> compatible components.
>
> All four machines can connect to the database and execute *most*
> queries. However, on three of the four client apps, opening certain
> query freezes that computer to a point where ctrl-alt-del does not
> even work.
> The server and a fourth terminal *can* always execute the same query
> without any problem at all, though.
>
> Another symptom: if one client app is working fine (no freezes) and
> then a second terminal opens the ¡§offending¡¨ query, the first PC
> *seems* to hang, but after pushing the reset button on the second
> terminal, life returns to the first one and client app. returns to
> normal behavior. Note that server is unaffected even when one or more
> terminals are frozen.
>
> And as I said before, there is this fourth terminal that can safely
> open the query all the time, just like the server can. Yesterday
> everything was fine on the network, problem came up this morning.
>
> Here¡¦s what has been done so far:
>
> In the server:
> -Reboot ļ
> -Uninstall/reinstall FB 1.0 server
> -Database sweep, backup and restore
>
> In the terminals:
> -Reboot ļ
> -Uninstall/reinstall FB 1.0 server
>
> No luck yet. At this time I don¡¦t know the exact SQL of the query
> that is causing havoc (there are several queries on that form)
> because right now I am in a different city. Tonight I¡¦ll drive to my
> client¡¦s place in order to take a closer look at the problem.
>
> I desperately need more ideas to try out tomorrow. All
> guidance/suggestions/pointers are welcome.
>
> Thanks a lot,
>
> -Benton
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/