Re: Executing lengthy query through ADO 2.7

From: Kskarthik001 (Kskarthik001_at_discussions.microsoft.com)
Date: 09/25/04 

Date: Sat, 25 Sep 2004 06:39:03 -0700

Hi Val Mazur,
   
      In my application, there will occur 2 scenarios to fetch the SAME bulk
of data from database using 2 different queries. In scenario 1, I will use a
short query(depending on user input in UI) to query the bulk of data. In this
scenario, ADO returns all the data successfully. But in scenario 2, I will be
supposed to use a large query(depending on other inputs from user) to fetch
the same bulk of data. Here, ADO is incapable to accomodate the lengthy query
to pass it to the driver. So, this scenario gets failed. By the by, there is
no way to reduce the lengthy query. size of query metrics: Characters with
spaces = 25,122
   Pls provide a solution to handle the string size in ADO2.7

Regards,
karthik

"Val Mazur" wrote:

> Hi,
>
> If it is huge selection, then there is no magic and only way to do this is
> to increase hardware. I think there is something wrong in design of your
> application if you try to load huge result. There are usually better ways to
> accomplish some bulk actions.
>
> --
> Val Mazur
> Microsoft MVP
>
>
> "Kskarthik001" <Kskarthik001@discussions.microsoft.com> wrote in message
> news:735C62AA-CCEF-40F5-8A89-C8DAE361378A@microsoft.com...
> > Hi,
> > I am using ADO 2.7 in my MFC application. And I am using
> > Provider=OraOLEDB.Oracle.1 for Oracle 8.1.6
> > In that, I will be framing a lengthy query as a variant and executing that
> > query using Open method of RecordSet object. I am getting an error of
> > "Not enough storage is available to complete this operation".
> > If I reduce the query size by compromising some constraints, the query is
> > executing fine.
> > Please provide me a solution ASAP.
>
>
>

Relevant Pages

  • Re: Complex form popup problem: warning...longwinded
    ... command button that launched the other form. ... main form that allows the user to fill out the scenario information, ... The majority of the fields in the query that are the recordsource of the ... remainder belong to the new record that was programmatically saved. ...
    (microsoft.public.access.formscoding)
  • Re: Rowsource on Report Chart?
    ... Thanks Guys - I figured the Persistent Query was the way to go. ... the Open Report procedure or does it need to be fired before even raising ... >> report for which I need to set the rowsource. ... >> 'Set recordsource to the sql for the particular scenario ...
    (microsoft.public.access.reports)
  • Re: requery vs. refresh vs. Remove Filter/Sort
    ... Can you give me a scenario to reproduce it? ... copy of the query, rather than rebuilding the query from ... .ListCount instead of .ReQuery. ...
    (microsoft.public.access.formscoding)
  • Re: Transaction when client shutdown
    ... I check your scenario, and I find that you right. ... now, in one connection run this code, and stop it immediately by pressing ... button in SQL Query Analyzer: ... connection RollBack or Commit!! ...
    (microsoft.public.sqlserver.programming)
  • Complex form popup problem: warning...longwinded
    ... main form that allows the user to fill out the scenario information, ... The majority of the fields in the query that are the recordsource of the ... remainder belong to the new record that was programmatically saved. ... There is a lot of code making this work and a lot of queries involved, ...
    (microsoft.public.access.formscoding)