Possible memory leak - error '800a0007' 
Author Message
 Possible memory leak - error '800a0007'


I have code which looks like the following:-

Set rsTest1 = Server.CreateObject("ADODB.Recordset")
rsTest1.Open ...
If rsTest1("field") = aValue Then
    statement 1
    Set rsTest2 = Server.CreateObject("ADODB.Recordset")
    rsTest2.Open ...
    If rsTest2.EOF Then
        statement 2
        statement 3
    End If
    Set rsTest2 = Nothing
End If
Set rsTest1 = Nothing

If I run this code, I get a "Provider error '800a0007' Out of memory" error.
When I comment out the If rsTest2.EOF Then line then the error no longer
I've had a quick look on the MS web site but there seems to be no info on
this particular error number.
Has anyone ever come across this error and resolved it ?


Sun, 17 Nov 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Microsoft VBScript runtime error '800a0007'

2. Microsoft VBScript runtime error '800a0007'

3. JScript Error: 'Out of Memory', Arrgghh!!

4. DevSoft HTTP32.OCX doesn't unload - memory leak

5. Out of memory error (800a0007) inside MTS object

6. Out of memory error 800A0007

7. No error reported and memory leak if error occurs in Class_Terminate

8. Possible 'Office Developer Documentation' Error

9. possible 'find' error

10. 'Out of Memory' error problem

11. VB6 'Out of Memory' Error

12. 'runtime error 2004' out of memory


Powered by phpBB® Forum Software