idbc error 8007000e - Not enough space on temporary disk

[avivit]

I got the above error, and somehow could not find
what it means.What temporary disk is it talking about? Mine or the servers'? Why? What uses it anyway? Shall I increase it? Shall the admin increase?
I got it once.
Btw - I use the getRows method, if it matters.
Thanks

 

[shaddow]

If u use GetRows method is faster then usual method but if your querry return lots of records using GetRows it may consume your memmory and if u have more then one user who did that the memmory will be consumed and then the sistem will need more virtual memmory or the Database provider needs more temporary space to store your arrays from Get Rows Method...
So u need to use or the old method MoveNext or Move or GetRows using Paging to on the Recordset... with an little amount of records ________
George, M

 

[avivit]

Thanks.
Ok ok, I made a spelling mistake (in purpose) and added signs like ;, numbers, spaces, just to check what will happen.
That's where it happened. Once. A second after I could do anything, including repeating this one.
I gotcha.
On the other hand, it can't be that I caused it, for there was no such record to match the query.
so I guess someone else caused it at the same time?.
Anyway how many r MANY records?
The whole db is only 4000 records.
It's MS-ACCESS db(Pls don't say a bad word about ACCESS).
Where exactly is it all stored when I use getRows?
I understand it's in the server's memories. right?
What Paths eaxctly? (of the temp..)
I am not the admin, but I'd like to ask to have it fixed.I am the asp programmer.
Thanks

 

[avivit]

I checked with the admin, and we have over 10 GB size of temporary disk on server. The max records selected/shown are 400 in one page.
How can it be that we r short of memory. Can it be something else? Can it be permissions issue?
We get this msg randomally, once a day or a week.
Nothing systematic.
Thanks