Hanging on Query->Open

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

Article #3100

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

#3100

From: GoJohnnyGoGoGoGo
Date: Tue, 17 Dec 2002 14:48

20 lines
1868 bytes

I have an application in place at 2 locations, both Windows 2000 machines,
one into an Oracle DB and one into Access.

The application occasionally hangs on a TADOQuery->Open command. On both
machines the latest version of MDAC was not installed but now has been and
at the Oracle location we have had a recurrence. The particular select
statement is running every 10 seconds polling the database for changes;

select * from vw_newJob where jobstatus_code = 'AS' and transactions_version
= 3

and is running with another 6 queries. This application has worked fine for
at least a couple of weeks without restarting the application (service).

Has anyone seen anything similar and if so, how did you fix it. Are there
memory/resource problems with ADO? Should the service be restarted overnight
as a matter of course?

Regards,
Paul

Technical Details

Message-ID: <3dff38f7$0$241$ed9e5944@reading.news.pipex.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!diablo.theplanet.net!newsfeed.esat.net!lnewspeer01.lnd.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,da030048df5f4586,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-12-17 06:47:47 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!diablo.theplanet.net!newsfeed.esat.net!lnewspeer01.lnd.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail
From: "GoJohnnyGoGoGoGo" <paul@spamoff.spongefactory.co.uk>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Hanging on Query->Open
Date: Tue, 17 Dec 2002 14:48:17 -0000
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
Lines: 22
Message-ID: <3dff38f7$0$241$ed9e5944@reading.news.pipex.net>
NNTP-Posting-Host: news.threex.co.uk
X-Trace: 1040136439 reading.news.pipex.net 241 195.217.229.125
X-Complaints-To: abuse@uk.uu.net