commandTimeout? connectionTimeout?

Article View: borland.public.delphi.database

Article #26

Back to borland.public.delphi.database Previous Next

#26

From: dmjsky
Date: Sun, 26 Jan 2003 10:58

20 lines
2026 bytes

Hi

I have been trying to replicate the errors I get in my Delphi/ms access app,
when our network does a 'go slow' (sometimes it grinds to a halt just while
showing the desktop) by opening the ms Access table in design mode while the
app is trying to insert/post to that table.

In order to overcome the problem I have experimented with increasing the
commandTimeout as I thought this property controlled how long the app would
try to connect to the database before causing an exception. However, I can
see no difference between the default values and anything up to 3600!!! I
thought this was 'time' measured in seconds, in which case I would have
expected to be able to easily measure the time before the exception was
triggered.

What have I got wrong?

Thanks for any help

Pete

Technical Details

Message-ID: <b10ei2$iia$1@news6.svr.pol.co.uk>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!diablo.theplanet.net!news.theplanet.net!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,b0f539c5c1a816e6,start
X-Google-Attributes: gidffff5,public
X-Google-Thread: f5cad,b0f539c5c1a816e6,start
X-Google-Attributes: gidf5cad,public
X-Google-Thread: 115d96,b0f539c5c1a816e6,start
X-Google-Attributes: gid115d96,public
X-Google-ArrivalTime: 2003-01-26 02:50:42 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!diablo.theplanet.net!news.theplanet.net!not-for-mail
From: "dmjsky" <dmjsky@dmjsky.fsnet.co.uk>
Newsgroups: borland.public.delphi.database,borland.public.delphi.database.ado,comp.lang.pascal.delphi.databases
Subject: commandTimeout? connectionTimeout?
Date: Sun, 26 Jan 2003 10:58:07 -0000
Lines: 22
Message-ID: <b10ei2$iia$1@news6.svr.pol.co.uk>
NNTP-Posting-Host: 217.134.111.22
X-Trace: news6.svr.pol.co.uk 1043578242 19018 217.134.111.22 (26 Jan 2003 10:50:42 GMT)
NNTP-Posting-Date: 26 Jan 2003 10:50:42 GMT
X-Complaints-To: abuse@theplanet.net
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600