Article View: borland.public.cppbuilder.database.ado
Article #3816Help! Estimated query processing time exceeds limit!
From: Mountain Lan
Date: Mon, 03 Jun 2002 04:39
Date: Mon, 03 Jun 2002 04:39
10 lines
1447 bytes
1447 bytes
Hello, everyone! I am using ADO to access DB2/400. When the program executes some SQL statements, an error message ' Estimated query processing time ??? exceeds limit 30' is reported from the host. The same statements can be executed normally in SQL Explorer. I have tried to modify the properties of ADOConnection, such as CommandTimeOut and ConnectionTimeOut, but it didn't work. What's wrong in it? Any comment from you are appreciated! Thanks Mountain
Technical Details
Message-ID:
<3cfaf303_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!peer1-sjc1.usenetserver.com!usenetserver.com!newsfeed1.cidera.com!Cidera!newsfeed.media.kyoto-u.ac.jp!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,2f18167a683aacb5,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-06-02 21:40:44 PST Reply-To: "Mountain Lan" <swatow@sina.com> From: "Mountain Lan" <swatow@sina.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: Help! Estimated query processing time exceeds limit! Date: Mon, 3 Jun 2002 12:39:12 +0800 Lines: 13 Organization: Ideal Tech X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 NNTP-Posting-Host: 61.130.146.71 Message-ID: <3cfaf303_2@dnews> X-Trace: dnews 1023079171 61.130.146.71 (2 Jun 2002 21:39:31 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!peer1-sjc1.usenetserver.com!usenetserver.com!newsfeed1.cidera.com!Cidera!newsfeed.media.kyoto-u.ac.jp!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews