Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2002

    Unanswered: Recordset.moveprevious

    I have a problem going backwards in a recordset I can go forward w/o a problem but if I try going to the previous record I get the following error:

    Operation is not allowed in this context.

    here is my connection routine I made comments b/c these things were throwing errors.

    SQLlookup = "SELECT * FROM prepress"

    Set connList = server.createobject("ADODB.Connection")
    connList.ConnectionString = aConnectionString
    'connList.CursorLocation = adUseClient

    Set results = server.createobject("ADODB.Recordset")
    results.ActiveConnection = connList
    results.CursorType = adOpenKeyset
    'results.LockType = adLockOptimistic
    results.Source = SQLlookup

    I've tried using different locktypes and cursor types but nothing seems to work. All help is appreciated. Thanks

  2. #2
    Join Date
    Oct 2002
    I needed to include this <!--METADATA TYPE="typelib" uuid="00000205-0000-0010-8000-00AA006D2EA4" --> and then everything worked thanks all.

  3. #3
    Join Date
    Feb 2002
    This is the typelib for ado 2.5 - did you just have to update your mdac or was this just left out of your page ?

  4. #4
    Join Date
    May 2003
    i tried to add the metadata line in the beggining of my asp file, like this:

    <%@ LANGUAGE = VBScript %>
    <% Option Explicit %>
    <!--METADATA TYPE="typelib" uuid="00000205-0000-0010-8000-00AA006D2EA4" -->

    i still cant use moveprevious and get that damn error "cant use in this context.."

    what did i do wrong?

    thanks, noam

Posting Permissions

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