ADO MoveNext not working

Discussion in 'Tech Talk' started by IHR, Nov 6, 2004.

  1. IHR

    IHR Appaloosa Rider

    Messages:
    285
    Likes Received:
    0
    Joined:
    Jan 5, 2003
    Location:
    Monroe, WA.
    I'm using an MS SQL database, using an ADO odbc connection. I can do a MoveFirst, MoveLast, but my MoveNext nexer gets to EOF. Anyone ever come across this?
     
  2. aspen

    aspen

    Messages:
    8
    Likes Received:
    0
    Joined:
    Apr 16, 2003
    Are you using ADO or ADO.NET. Give me a little more info and I will try to help you out.
     

  3. IHR

    IHR Appaloosa Rider

    Messages:
    285
    Likes Received:
    0
    Joined:
    Jan 5, 2003
    Location:
    Monroe, WA.
    I got it figured out.

    I am using ADO, not .net

    I was opening and closing the connection and result collection for every operation, instead of on page load open the connection and result collection, only closing them on page 'unload'.

    Thanks for the offer of help though!