What's the CPU utilization like on the server when the connection is lost?
Dave
--- On Wed, 4/14/10, c80840 <c80...@gmail.com> wrote:
From: c80840 <c80...@gmail.com>
Subject: [delphi-en] Losing connection to DB
To: delphi-en@yahoogroups.com
Date: Wednesday, April 14, 2010, 11:48 AM
Can someone tell me why I keep loosing connection to the database?
procedure TForm3.ThisCommand1 Click(Sender: TObject);
begin
datamodule2. IBSQL1.SQL. Clear;
datamodule2. IBSQL1.SQL. Add(datamodule2. IBTable2. FieldByName( 'commands_
').AsString+ ';');
if datamodule2. IBSQL1.Transacti on.Active = true then
begin
datamodule2. IBSQL1.Transacti on.Rollback;
end;
datamodule2. IBSQL1.Transacti on.StartTransact ion;
datamodule2. IBSQL1.Prepare;
if (datamodule2. IBSQL1.Prepared = true) then
begin
datamodule2. IBSQL1.ExecQuery ;
datamodule2. IBSQL1.Transacti on.CommitRetaini ng;
// I've also tried: datamodule2. IBSQL1.Transacti on.CommitRetaini ng;
// I lose the connection to the database on either
end;
end;
[Non-text portions of this message have been removed]
