All tables are TIBDataset , all have DataSource , all placed on a TDataModule (named dm).

I use forms with simple TDBEdit, TDBComboBox etc components.

I Open these tables whenever needed in the program and input/output values, usually close after.

I use TIBQuery and TIBSQL components :

procedure Tproduse_form.btnDaClick(Sender: TObject);
var
my_ibquery:TIBQuery;
my_ibSQL:TIBSQL;
begin
my_ibquery := TIBQuery.Create(nil);
my_ibSQL := TIBSQL.Create(nil);
try
my_ibquery.Database := dm.database;
my_ibSQL.Database := dm.database;

..

finally
FreeAndNil(my_ibquery);
FreeAndNil(my_ibSQL);
end;
end;


can it be that somewhere I forgot to FreeAndNil a query ?

not montitoring, nothing special.

Also I use TQReport - but based on TIBQuery .

Usually I use TransCommit. And , of course, if I stop the program, I use Commit.

All the graphical stuff is connected to TIBDataset, (TIBDataset.Post, TIBDataset.Cancel , TIBDataset.Insert) etc .




Tiberiu






From: Dmitry Kuzmenko
Sent: Saturday, March 31, 2012 4:09 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] OIT / NT



Hello, Tiberiu!

TH> Nothing special. The same app, with the same database,
TH> the same amount of activity, works correctly for the same company ,
TH> from a different location. No bulk data, nu threads ...

Well, can you be more specific? For example,
your application just wait for user input, and then commits data,
or it is monitoring something by itself, or ...?

Since you are using IBX, I hope all transactions are explicit,
and there are no code that uses implicit transaction start and commit.

TH> I am wondering if maybe some troyan sends spam packets
TH> to the server, from this system, on port 3050.

It can't be. Consider that only your application generates
transactions.
Use FBScanner, FBTraceManager, or audit in FB 2.5 - any of these - to
understand what your application is doing.

--
Dmitry Kuzmenko, www.ib-aid.com





TODAY(Beta) . Powered by Yahoo!
Ousted 'Idol' star's hilarious exit interview
Heejun Han talks about dinosaurs, fireworks on his armpits, and being on Steven Tyler's bad side.

Privacy Policy


[Non-text portions of this message have been removed]