close

Privacy guaranteed - Your email is not shared with anyone.

ADO MoveNext not working

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

  1. IHR

    IHR Appaloosa Rider

    Joined:
    Jan 5, 2003
    Messages:
    285
    Likes Received:
    0
    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

    Joined:
    Apr 16, 2003
    Messages:
    8
    Likes Received:
    0
    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

    Joined:
    Jan 5, 2003
    Messages:
    285
    Likes Received:
    0
    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!