ADO Memory Leak

Discussion in 'ASP General' started by Andrew Durstewitz, Jan 14, 2004.

  1. Hi!

    I'm having a problem that I can only attribute to something that I don't
    know about ADO. I am using an ADODB.Connection with .CursorLocation = 3
    since I am using MSSQL with text fields.

    I am running a large set of 4 LEFT JOINS (5 tables in all). Currently
    my recordset is returning 168 rows and 23 colums. After looping through
    the ADO connection 27 times (creating a pdf report for users to print)
    the data goes nutz. I have tried using different inputs and no matter
    what on the 27th time is stops.

    Any ideas?
    Andrew J Durstewitz

    DEVBuilder.org, http://www.DEVBuilder.org
    ASP,ASP.NET,VB.NET,PHP,Java,and SQL Support, all in one place.
    Andrew Durstewitz, Jan 14, 2004
    #1
    1. Advertising

  2. "Andrew Durstewitz" <> wrote in message
    news:400593e8$0$70302$...
    > Hi!
    >
    > I'm having a problem that I can only attribute to something that I don't
    > know about ADO. I am using an ADODB.Connection with .CursorLocation = 3
    > since I am using MSSQL with text fields.
    >
    > I am running a large set of 4 LEFT JOINS (5 tables in all). Currently
    > my recordset is returning 168 rows and 23 colums. After looping through
    > the ADO connection 27 times (creating a pdf report for users to print)
    > the data goes nutz. I have tried using different inputs and no matter
    > what on the 27th time is stops.


    > Any ideas?


    Best is to have recent drivers.

    ADO 2.8 is latest and you should utilize sqloledb as provder in your
    connection string (to have the smallest code footprint thus elimating
    leaks)...

    --
    compatible web farm Session replacement for Asp and Asp.Net
    http://www.nieropwebconsult.nl/asp_session_manager.htm


    > Andrew J Durstewitz
    >
    > DEVBuilder.org, http://www.DEVBuilder.org
    > ASP,ASP.NET,VB.NET,PHP,Java,and SQL Support, all in one place.
    Egbert Nierop \(MVP for IIS\), Jan 15, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. nita
    Replies:
    1
    Views:
    851
    Saravana
    Nov 20, 2004
  2. ronaldlee

    Transfer ADO Code to ADO.NET

    ronaldlee, Dec 17, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    443
    Kevin Spencer
    Dec 17, 2004
  3. Replies:
    0
    Views:
    1,296
  4. s.subbarayan

    Dynamic memory allocation and memory leak...

    s.subbarayan, Mar 18, 2005, in forum: C Programming
    Replies:
    10
    Views:
    675
    Eric Sosman
    Mar 22, 2005
  5. Navin
    Replies:
    1
    Views:
    667
    Ken Schaefer
    Sep 9, 2003
Loading...

Share This Page