""Dave Bullar"" wrote

> Help Please !
> Are there any known problems with iboEvents and Firebird and
> connect/disconnect.
>
> I have a program (modified iboReplication) which I want to call

periodically

> every 15 mins and disconnect from the server afterwards.
>
> Program runs fine for precisely 20 cycles then freezes. (Timer delay set

to

> 10 seconds in place of 15 minutes for test purposes)
>
> If I comment out the 'eventRegister' line of code the program cycles fine
> (but of course does not function as intended). The events do not arise in
> either case (but they will in practice). I wondered whether the

'unregister'

> was being called at disconnect, but it is.
>
> Is something like a buffer being left uncleared by unregister ?
>
> when program freezes it is always doing a 'disconnect'. And after a while

I

> get a 'cannot connect to server' message. And other programs such as

IB_SQL

> cannot then connect to server. It can be released only by 'server stop /
> server start'.
>
> I should add that the 'server' is an old PC being used for test purposes
> running win98.
>
> As soon as possible I will try it at work with a proper server but won't

be

> popular if that has to be stopped and started !!
>
> Connect/Disconnect/connect can recycle happily at 300ms intervals between
> each.
> Connect/ run program /disconnect/Connect etc can recyle happily at 1

second

> intervals between each of if register events is commented out.
> Freezes after 20 cycles if events are registered even though events don't
> happen.

Should I understand from your message that it freezes after 20 minutes?
Or more precisely after 20 "register - unregister" events?

There are some isues with the firebird server and events regarding network
problems.
If by any chance an event connection request from the server does not work
the server
will wait forever for the client to respond.

Are you sure the register events are succesful?

Is it posible that your network might break down from time to time?

Do you have any firewalls?

What version of Firebird are you using?

What OS is the client?


--
Best regards,
Application Developer
Pirtea Calin Iancu
S.C. SoftScape S.R.L.
pcalin@...