Problems with Demo -> Alerter

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
-ChrisE-
Posts: 17
Joined: Tue 22 Jun 2010 12:40

Problems with Demo -> Alerter

Post by -ChrisE- » Tue 22 Jun 2010 12:52

Hello,

i tried your product-demo with Delphi 2007 and Firebird 2.1.3 SuperServer. I created the Database and everything works fine. But the Alerter-Demo doesn't work.
First I clicked the Open-Button. Then the Create-Button. I can see in Flamerobin that the Create-Scripts are done (one Stored-Procedure and three Trigger-Events for the table DEPT). But when I press the Register-Button the Applications freeze.
I also tried to make an new Projekt with only an Alerter for the Triggerevents. It also freeze.

When I debug, I can see that it freeze at this position:

Code: Select all

procedure TAlerterFrame.btRegisterClick(Sender: TObject);

  procedure RegisterFor(Alerter: TIBCAlerter; Proc: TIBCStoredProc);
  begin
    Alerter.Stop;
    if rbTriggers.Checked then
      Alerter.Events.Text := edTrEvent.Text
    else
      Alerter.Events.Text := edPrEvent.Text;
    Alerter.Start;
    Proc.Prepare; >
    Proc.ParamByName(PrEvent).ParamType := ptInput;
    Proc.ParamByName(PrEvent).AsString := edPrEvent.Text;
  end;

begin
  Connect;
  RegisterFor(IBCAlerter1, IBCStoredProc1);
  RegisterFor(IBCAlerter2, IBCStoredProc2);
  SetControlsEnabled(False);
end;
So whats is wrong? Is there something to configure at the Firebird-Server?

Thanks for help.

Chris

-ChrisE-
Posts: 17
Joined: Tue 22 Jun 2010 12:40

Post by -ChrisE- » Wed 23 Jun 2010 08:29

Ok,

everthing is ok :-)

I just forgot to enabled an static port in the firebird.conf and in the Windows-Firewall for Event-Communication.

Chris

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 23 Jun 2010 08:33

I can not reproduce the problem. Please, check that you have the latest IBDAC build (3.10.0.14).

-ChrisE-
Posts: 17
Joined: Tue 22 Jun 2010 12:40

Post by -ChrisE- » Wed 23 Jun 2010 09:36

Hello Dimon,

as I wrote above everything works now. It was just an wrong configured EventPort in the FireBird-Server (firebird.conf).

[Edit]... so the the server Windows-Firewall blocked the event communication...[/Edit]

The Version is 3.10.0.14.

THX for reply.

Chris

Dimon
Devart Team
Posts: 2910
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 23 Jun 2010 09:50

It is good to see that this problem has been solved.

Post Reply