Re: Memory leak in ado
- From: Zaza Turmanidze <ZazaTurmanidze@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 14 Apr 2008 04:51:00 -0700
Hi Bob,
1. My recordset must be keep open because end-user must delete and add some
parts of current recordset.
2. I tried my code in MDAC 2.8 and this problem still active
Any help would be appreciated.
"Bob Barrows [MVP]" wrote:
Zaza Turmanidze wrote:.
Hi,
I'm using ADO 2.7 and have memory leak when I try several times add
and delete records. See code (VB6)
Dim RS As ADODB.Recordset
Private Sub Main()
Dim counter As Long
Set RS = New ADODB.Recordset
RS.Fields.Append "Name", adVarChar, 255
RS.Open , , , adLockOptimistic
For counter = 1 To 100
Add_Records
Delete_Records
Next
MsgBox "Complete"
End Sub
The only issue I can see is that you never close the recordset.
Try upgrading to MDAC 2.8.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
- Follow-Ups:
- Re: Memory leak in ado
- From: Bob Barrows [MVP]
- Re: Memory leak in ado
- References:
- Memory leak in ado
- From: Zaza Turmanidze
- Re: Memory leak in ado
- From: Bob Barrows [MVP]
- Memory leak in ado
- Prev by Date: Re: Memory leak in ado
- Next by Date: Re: Memory leak in ado
- Previous by thread: Re: Memory leak in ado
- Next by thread: Re: Memory leak in ado
- Index(es):
Relevant Pages
|
|
