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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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
[EMAIL PROTECTED]

 

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.
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi

Reply via email to