Subject | TIBEvents->RegisterEvents(); |
---|---|
Author | Johannes Krackowizer |
Post date | 2002-07-25T14:18:06Z |
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]
/***************************************************************************
***/
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]