Re: ADO - permanent memory leak?!

From: Jeff Dyer (jeff.nospam_at_trustguard.co.uk)
Date: 10/22/04


Date: Fri, 22 Oct 2004 16:46:13 +0100

Michal - are you using MemProof 9.5.0? I just reported the same problem to
Atanas and it appears to be a fault in MemProof. I was advised to delete the
HookCOM.hlx file.

Jeff

"Michal R" <michal@topindex.cz> wrote in message
news:4178ec03@newsgroups.borland.com...
> Can somebode help me with ADO memory leaks?!
>
> Problem is in a few memory object which stays in memory - detected by
> MemProof:
>
> 1677 SysString 00168894 15
> SysAllocStringLen(ISAUTOINCREMENT,15)
> 1709 SysString 00168894 15
> SysAllocStringLen(ISAUTOINCREMENT,15)
> 1716 SysString 00168894 15
> SysAllocStringLen(ISAUTOINCREMENT,15)
> 1723 SysString 00168894 15
> SysAllocStringLen(ISAUTOINCREMENT,15)
>
> Source module is oleaut32.dll.
>
> When followed simple code is called in a loop, used memory by application
> is still growing till...:(
>
> A'm using D7 Prof with SP 1, Win XP and data provider is
> Microsoft.Jet.OLEDB.4.0 (Access DB).
> I also have tried with ODBC provider and MySQL server and problem is the
> same. The only one difference is in
> memory object which stays in memory (for access 22, for odbc/mysql 13).
>
> Thanks for help, Michal R.
>
> A have used this simple code:
> ------------------------------------------
> procedure TForm1.specproc;
> var q:TADOQuery;
> begin
> q:=TADOQuery.Create(nil);
> try
> q.SQL.Clear;
> q.Connection:=ADOConnection1;
> q.SQL.add('select * from mon');
> q.Active:=true;
>
> {....}
>
> q.Active:=false;
> finally
> q.Free;
> end;
> end;
>
>



Relevant Pages

  • Re: ADO - permanent memory leak?!
    ... > Atanas and it appears to be a fault in MemProof. ... >> Can somebode help me with ADO memory leaks?! ...
    (borland.public.delphi.database.ado)
  • Re: ADO - permanent memory leak?!
    ... I have a memory leak in an application that makes repeated ... I have ADO 2.7 ... I am using MemProof 9.5.0 to isolate the problem. ... These are the only "memory growth" items. ...
    (borland.public.delphi.database.ado)
  • Re: Question about FastMM
    ... Sorted by memory block size. ... Not as good as MemProof et al, but it's free, it does not ... be fine) and close the application, FastMM will show me _immediately_ that I ...
    (borland.public.delphi.non-technical)
  • Re: Undetected memory leaks?
    ... >> Even after checking with MemProof and MemCheck the Application ... >> Windows Task manager shows that the program memory size slowly ... >> memory allocated. ...
    (comp.lang.pascal.delphi.misc)
  • Re: Memcheck versus Memproof
    ... Could anyone explain to me what the Memproof error would be, ... but my experience with MemProof shows that it ... reports loots of errors that does not belong to my code. ... Also note that Windows will free all memory your program used ...
    (borland.public.delphi.thirdpartytools.general)