[DUG] Database connection

[Hayward, Phillip]

Interbase log is telling us nothing useful.

How isolated are the database update mechanisms? Good questions. Working
through that. My skill set is relatively light in Delphi having just
migrated from a purely Oracle environment.

They aren't headless apps and I believe this is where a lot of the
issues may come from, among other things. These are applications which
were created way back when Delphi 4 was hot and recently just recompiled
in Delphi 2005. They were built to run at an open console on a desktop
PC in quite a small local environment. The network has grown somewhat
and they need to be moved onto servers and run as services if possible.


Phil 

 

 

From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz]
On Behalf Of Richard Vowles
Sent: Wednesday, 20 September 2006 4:48 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: RE: [DUG] Database connection

 

What does your interbase log say is happening?

 

How isolated are your database update mechanisms or at least your
getting of the connection? I would presume this is a headless app
(pretty much) and so you aren't using many data aware controls?

 

Richard

 

________________________________

From: delphi-bounces at ns3.123.co.nz on behalf of Hayward, Phillip
Sent: Wed 20/09/2006 16:27
To: NZ Borland Developers Group - Delphi List
Subject: [DUG] Database connection

We have some applications that we have passing data from an OPC server
to the database.

We leave them running overnight and generally no issues.

Occasionally there is a loss of connection to the database resulting in
the applications going into io error.

We are using Delphi 2005, and BDE connections to  Interbase 7.5.1 via
the network.

OPC doesn't present us with a problem as the OPC server resides on the
same machine.

We wish to revamp these applications so that in the event of a temporary
loss of connection to the database it will catch this and recover rather
than getting an IO issue.

 

Any thoughts as to where we might start in order to make the process
more robust?

 

Regards 
Phil Hayward

System Analyst 
Pinepanels Rangiora
ph  (64) 3 313-2764
fax (64) 3 313-2739
Ext 38824
Phillip.Hayward at chh.co.nz

 

DISCLAIMER:  This electronic message together with any attachments is
confidential.  If you are not the intended recipient, do not copy,
disclose or use the contents in any way.  Please also advise us by
return e-mail that you have received the message and then please
destroy.  Carter Holt Harvey is not responsible for any changes made to
this message and / or any attachments after sending by Carter Holt
Harvey.  We use virus scanning software but exclude all liability for
viruses or anything similar in this email or any attachment. 


DISCLAIMER: This electronic message together with any attachments is 
confidential. If you are not the intended recipient, do not copy, disclose or 
use the contents in any way. Please also advise us by return e-mail that you 
have received the message and then please destroy. Carter Holt Harvey is not 
responsible for any changes made to this message and / or any attachments after 
sending by Carter Holt Harvey. We use virus scanning software but exclude all 
liability for viruses or anything similar in this email or any attachment.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://ns3.123.co.nz/pipermail/delphi/attachments/20060921/3d08f54f/attachment.html