Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

8007000e: Not enough storage is available to complete this operation

Status
Not open for further replies.

earme

Programmer
Jul 27, 2000
155
US
Hello, I'm getting the error 8007000e, "Not enough storage is available to complete this operation." It's running Windows 2000 and has at least 2gig free and the task manager doesn't show that anything is hogging memory.
The code that it happens on is
Code:
alldata=rstemp.getrows()
in:
Code:
set rstemp=Server.CreateObject("ADODB.Recordset")
aduseclient=3
rstemp.cursorlocation=aduseclient
rstemp.cachesize=pagesize
rstemp.PageSize=pagesize
rstemp.open parmSQL,parmconn
pagemax=cint(rstemp.pagecount)
recordnum=cint(rstemp.RecordCount)
parmdict.add "pagemax", pagemax
if not(rstemp.eof) then
	alldata=rstemp.getrows()
end if
rstemp.close
set rstemp=nothing
conntemp.close
set conntemp=nothing
The problem started when I opened the dsn I'm using to make a connection and saved it, but I don't think I made any changes to it. I went back and looked at it again, and it looks the way it should.

Please help!
Earme
 
An update and some more info.
The machine runs 2 websites, both accessing a SQL database, but with different DSN's. The other web site ran fine, even while I was pulling my hair out with the other (which was good, cause it left me some hair).
All of this was happening Sunday night, I went to bed and when I woke up, 6 hours later, it was working.
Don't know why it decided to randomly start working, but I'm glad it did.

Earme
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top