Subject | Re: [IBO] Events and freeze.. |
---|---|
Author | Thomas Steinmaurer |
Post date | 2009-03-27T11:14:33Z |
>> Delphi 7, IBO 4.6A, FB 1.5.Btw, are events using randomly choosen ports in your case? If so, then
>>
>> My application wants to be informed of changes in a database.
>>
>> If possible, I use a TIB_Events for this.
>>
>> Sometimes it is not possible to use events, due to firewalls, using
>> superserver behind a NAT_router, or whatever. No problem, I can poll for
>> changes.
>>
>> I would like the application to automattically try to use events and if
>> not possible, use polling.
>>
>> But... if I call TIB_Events.RegisterEvents on a connection where no
>> secondary connection can be opened, following things happen:
>>
>> 1. After a delay of about 20 sec an error pops up saying that its
>> impossible to create a secondary connection for events. OK.
>> 2. I cannot confirm (click on OK) the error. The app is frozen. Need
>> taskmanager to kill it.
>>
>> If I catch the error in a try except, same thing happens. Freeze.
>>
>> I usually put the call to RegisterEvents in the
>> IB_Connection.AfterConnect. If I try to registerEvents on a buttonclick,
>> same thing happens.
>>
>> Any thoughts?
>
> There has been quite some improvements and bug fixes in the Firebird
> engine since 1.5 concerning events. You will find quite some entries in
> the Firebird tracker. http://tracker.firebirdsql.org
>
> I'm not entirely sure if upgrading to 2.0 or 2.1 would entirely solve
> the problem for your situation. Also you are using an IBO version which
> isn't compatible with Firebird 2.x. Upgrading would be quite a route for
> you, because:
>
> * Test your application with a newer IBO version with 1.5 first
> * Upgrade to Firebird 2.x
> * Test your application with the newest IBO version and Firebird 2.x
>
> but doable.
set the RemoteAuxPort configuration parameter in firebird.conf and open
that port in the firewall. Although, this parameter only works with
SuperServer.
--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/