RE: "not enough storage ...." error using GetRows
From: danreber (danreber_at_discussions.microsoft.com)
Date: 01/28/05
- Next message: Danny Crowell: "Strange behavior with a Sybase stored procedure"
- Previous message: danreber: ""not enough storage ...." error using GetRows"
- In reply to: danreber: ""not enough storage ...." error using GetRows"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 28 Jan 2005 11:31:04 -0800
More info:
I tested the app in the VB IDE. I placed a breakpoint at
DataArray = rsData.GetRows(adGetRowsRest)
At that point I had 1.55 GB of RAM (out of 2GB) available. When GetRows was
called the amount of RAM spiked to 550 MB RAM used, the error was raised and
the RAM went back down to 450 MB used. I copied the line of code to the
immediate window. After executing the line and getting the error three
times, on the fourth time the line ran fine and the rest of the code worked
without any issues.
So I don't think that it is a system resources issue.
"danreber" wrote:
> I have a client that is returning >600K rows from a sql server using a VB
> application. I am referencing ado 2.6 in the app but he has windows xp sp2
> (I think that has ado 2.8???). When the data is fetched I use GetRows to
> poplulate an array. As soon as GetRows is called I get an error "not enough
> storage is available to complete this operation".
>
> I have searched the internet and I can't find much about it. I did find a
> refernce to AppenChunck but I am not using that.
>
> I tested the app on my PC
>
> 2 GB RAM
> 3.6 GHtz
> Windows XP SP 2
> MDAC 2.8 SP1
>
> and I get the same error. Does anybody have any ideas?
>
> Thanks
>
> danreber
- Next message: Danny Crowell: "Strange behavior with a Sybase stored procedure"
- Previous message: danreber: ""not enough storage ...." error using GetRows"
- In reply to: danreber: ""not enough storage ...." error using GetRows"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
