timeout expired (SQL server 7)

Article View: borland.public.cppbuilder.database.ado

Article #3129

Back to borland.public.cppbuilder.database.ado Previous Next

#3129

From: jan petersen
Date: Thu, 14 Nov 2002 13:42

6 lines
1302 bytes

Im using a ADOQuery to delete some rows in my db, the connection is setup
using a ADOConnection. My problem is the query timeout from time to time.
I have tried change the commandtimeout property but to no effect, after 30
sec of waiting i get the timeout expired - what am i doing wrong ?

thx in advance.

Technical Details

Message-ID: <3dd3a863@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-05!sn-xit-06!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,7ae5e6dcfc2bbcdd,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-11-14 06:38:08 PST
From: "jan petersen" <jan@rmas.dk>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: timeout expired (SQL server 7)
Date: Thu, 14 Nov 2002 14:42:58 +0100
Lines: 9
Organization: ritzaus medieservice A/S
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 129.142.53.13
Message-ID: <3dd3a863@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1037281379 129.142.53.13 (14 Nov 2002 05:42:59 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-05!sn-xit-06!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail