i have also tried Borland IB6 for linux and triggers only works sometimes.
the only way to get IB6 working corectly is to install IB6 under windows.

Johannes


-----Ursprungliche Nachricht-----
Von: Ola Samuelson [mailto:ola@...]
Gesendet: Donnerstag, 25. Juli 2002 20:50
An: ib-support@yahoogroups.com
Betreff: Re: AW: [ib-support] TIBEvents->RegisterEvents();


Hi!
Known bug/problem as far as i can tell.
I can't make events work, same problem crash db when registered.
Worked with Borland IB 6 beta, but not with FB.
Has nothing to do with langage or dev components as far as i know.
Must be gds32.dll and i am pretty sure it has NOTHING to do with
networking or firewalls.
Other ideas?
TIA
//OLAS



Johannes Krackowizer wrote:

>i have also used gds32.dll version 6.0.0.627 and the software
>starts but if i do anything in the database the software crashes and
>the server hangs.
>
>johannes krackowizer
>
>-----Ursprungliche Nachricht-----
>Von: Johannes Krackowizer [mailto:krjo@...]
>Gesendet: Donnerstag, 25. Juli 2002 16:18
>An: Ib-Support@Yahoogroups. Com (E-Mail)
>Betreff: [ib-support] TIBEvents->RegisterEvents();
>
>
>i use the following deffinition for the trigger in the database:
>
>/**************************************************************************

*

>***/
>
>SET SQL DIALECT 3;
>
>SET NAMES NONE;
>
>
>SET TERM ^ ;
>
>
>CREATE TRIGGER DATA_AI0 FOR DATA
>ACTIVE AFTER INSERT POSITION 0
>AS
>begin
>
> POST_EVENT 'NEWDATAREADY';
>end
>
>SET TERM ; ^
>
>/**************************************************************************

*

>***/
>
>then i use the following c-code:
>
>// ------------------------------------------------------------------------

-

>-----
>
>try
>{
> IBDatabase1->Connected = true;
> IBEvents1->UnRegisterEvents();
> IBEvents1->Events->Clear();
> IBEvents1->Events->Add("NEWDATAREADY");
> IBEvents1->RegisterEvents();
>}
>catch (Exception &exception)
>{
> Application->ShowException(&exception);
> Application->Terminate();
>}
>
>// ------------------------------------------------------------------------

-

>-----
>
>i use the following objects from C++:
>TIBDatabase
>TIBTransaction
>TIBDatabase
>TIBEvents
>
>then i get the following error code:
>
>Unable to complete network request to host "jandrim"
>Failed to establish a secondary connection for event processing.
>
>
>if i remark IBEvents1->RegisterEvents(); then i could access
>the database normal (read/write).
>
>the same happens when i use Delphi.
>
>hardware/software:
>server:
> linux (kernel 2.4.18)
> Firebird 1.0 stable
> one nic (ip-addr: 192.168.100.12)
>
>client:
> windows 2000 SP2
> one nic (ip-addr: 192.168.100.70)
> gds32.dll (6.5.0.28)
>
>there is no (!!!) firewall
>
>thanks for support
>
>johannes krackowizer
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/