[DUG] Database connection

[Hayward, Phillip]

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://ns3.123.co.nz/pipermail/delphi/attachments/20060920/e26c5643/attachment.html