[DUG] Database connection

[Richard Vowles]

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. 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 6034 bytes
Desc: not available
Url : http://ns3.123.co.nz/pipermail/delphi/attachments/20060920/4d6a6a19/attachment-0001.bin