Re: ADO Exception on 300.000 records or more !!

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

Article #3980

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

#3980

From: Jurko
Date: Wed, 01 May 2002 09:04

30 lines
1889 bytes

Hmm nothing in ADOExpress should have anything to do with this... if it's
happening and its based only on the number of records then it's (most
likely)
an exception thrown by ADODB code. My guess is that it's running out of
memory at some point...

Why do you need to select so much information at one time? Maybe you
should rethink your design? Using server side cursors? Getting data in
batches?

HTH,
    Jurko

"Roberto" <roberto@dialtech.com.br> wrote in message
news:3ccef611_1@dnews...
> I'm getting a OLE Exception when I try to make a sample select that
returns
> a recordset with more than 300.000 records. This is a bug on ADO Express
> components ???
>
> --
> Roberto F. Lopes
> Diretor T�cnico
> Dialtech Telecomunica��es e Sistemas Ltda.
> Rua Humberto I, 236 - Vila Mariana - S�o Paulo - SP
> Fone/Fax: 5579-8200
> www.dialtechtelecom.com.br
> e-mail: roberto@dialtechtelecom.com.br
>
>

Technical Details

Message-ID: <l1boaa.cgt.ln@news.ve-mil.hr>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!195.40.4.120.MISMATCH!easynet-quince!easynet.net!oleane.net!oleane!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews!news.ve-mil.hr!not-for-mail

References: <3ccef611_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,66667d27ad441335
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-05-01 02:09:13 PST
From: "Jurko" <Jurko@ve-mil.hr>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3ccef611_1@dnews>
Subject: Re: ADO Exception on 300.000 records or more !!
Date: Wed, 1 May 2002 11:04:11 +0200
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <l1boaa.cgt.ln@news.ve-mil.hr>
NNTP-Posting-Host: 195.29.221.130
X-Trace: dnews 1020243936 195.29.221.130 (1 May 2002 02:05:36 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!195.40.4.120.MISMATCH!easynet-quince!easynet.net!oleane.net!oleane!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews!news.ve-mil.hr!not-for-mail

Reply to Parent Message