Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Location
    St Cloud
    Posts
    1

    Unanswered: Memory leaks with ado recordsets

    I am using ado recordsets to interact with SQL Server. The memory occupied by ado recordsets is not released even though the recordsets released deleted. I want to know how to free ado recordsets after using them. The virtual memory is occupied by my program and released only when program exists . Please help me to solve the problem.

    my email address is ilnarasimham@hotmail.com

    Thaking you
    Narasimham

  2. #2
    Join Date
    Jan 2003
    Location
    Dordrecht, The Netherlands
    Posts
    95

    Re: Memory leaks with ado recordsets

    Originally posted by ilnarasimham
    I am using ado recordsets to interact with SQL Server. The memory occupied by ado recordsets is not released even though the recordsets released deleted. I want to know how to free ado recordsets after using them. The virtual memory is occupied by my program and released only when program exists . Please help me to solve the problem.

    my email address is ilnarasimham@hotmail.com

    Thaking you
    Narasimham
    Try to add 'set rs = Nothing' at the end of your code block.

    Ad Dieleman.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •