Error Message

We are using ADO2.6,VB6.0, and SQLServer2000. There is a error message "Not
enough storage is available to complete this operation" when we try to
update a single row in a big table (more than 80 million records). We have
only see this message twice. Does anybody know what this error mean? At what
condition it could happen?
Thanks,
LijunHi Lijun
Is the transaction log full?
Cheers, David
>--Original Message--
>We are using ADO2.6,VB6.0, and SQLServer2000. There is a
error message "Not
>enough storage is available to complete this operation"
when we try to
>update a single row in a big table (more than 80 million
records). We have
>only see this message twice. Does anybody know what this
error mean? At what
>condition it could happen?
>Thanks,
>Lijun
>
>.
>|||David,
The transaction log is not full. I have allocated 30GB transaction log space
and the transaction log backup size is 70MB after the error message.
Lijun
"David" <anonymous@.discussions.microsoft.com> wrote in message
news:020c01c3b84f$4853e250$a501280a@.phx.gbl...
> Hi Lijun
> Is the transaction log full?
> Cheers, David
> >--Original Message--
> >We are using ADO2.6,VB6.0, and SQLServer2000. There is a
> error message "Not
> >enough storage is available to complete this operation"
> when we try to
> >update a single row in a big table (more than 80 million
> records). We have
> >only see this message twice. Does anybody know what this
> error mean? At what
> >condition it could happen?
> >
> >Thanks,
> >Lijun
> >
> >
> >.
> >|||Lijun, I don't know why this is happening - sorry. David.
>--Original Message--
>David,
>The transaction log is not full. I have allocated 30GB
transaction log space
>and the transaction log backup size is 70MB after the
error message.
>Lijun
>"David" <anonymous@.discussions.microsoft.com> wrote in
message
>news:020c01c3b84f$4853e250$a501280a@.phx.gbl...
>> Hi Lijun
>> Is the transaction log full?
>> Cheers, David
>> >--Original Message--
>> >We are using ADO2.6,VB6.0, and SQLServer2000. There is
a
>> error message "Not
>> >enough storage is available to complete this operation"
>> when we try to
>> >update a single row in a big table (more than 80
million
>> records). We have
>> >only see this message twice. Does anybody know what
this
>> error mean? At what
>> >condition it could happen?
>> >
>> >Thanks,
>> >Lijun
>> >
>> >
>> >.
>> >
>
>.
>|||Hi Lijun,
Thanks for your post. According to your description, it seems that this
error message does not occur regularly. This kind of randomly occurring
issue is not easy to troubleshoot, and is one whose root cause is difficult
to find out. Please check the suggestions in the following articles and see
if they address your problem.
182423 FIX: Error "Not Enough Storage Is Available" with ADO
http://support.microsoft.com/?id=182423
166840 Err Msg: Not Enough Storage to Complete Operation
http://support.microsoft.com/?id=166840
Please try to install the latest version of MDAC on your computer. You will
find the download link below.
Microsoft Data Access Components (MDAC) 2.7 Service Pack 1 Refresh
http://www.microsoft.com/downloads/details.aspx?FamilyID=9ad000f2-cae7-493d-
b0f3-ae36c570ade8&DisplayLang=en
When you update the table using Query Analyzer, does the error message
occur?
In addition, based on my experience, this issue is probably related to the
ado programming. It is best to discuss this issue in the
microsoft.public.vb.database.dao newsgroup. The
microsoft.public.vb.database.dao newsgroup is primarily for issues
involving ado programming. The reason why we recommend posting
appropriately is because you will then get the most qualified pool of
respondents, also, other partners who regularly read the newsgroups
regularly can either share their knowledge, or learn from your interaction
with us.
Thanks for using MSDN newsgroup. If you have any questions, please do not
hesitate to let me know.
Regards,
Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.