0 Replies Latest reply on Aug 15, 2007 9:23 AM by Newsgroup_User

    move to record error - update

    Level 7
      (sorry, minor update to previous post...)
      Hi all,

      I have an error which doesn't for some reason (doesn't) always rear it's
      ugly head.
      Basically it's part of the repeat region/move to record functionality of
      DreamWeaver 8

      The error message is:
      Microsoft OLE DB Provider for SQL Server error '80040e14'
      Could not find prepared statement with handle -1.

      This is the code block:
      ' reset the cursor to the beginning
      If (MM_rs.CursorType > 0) Then
      MM_rs.MoveFirst
      Else
      MM_rs.Requery ' this is the offending line
      End If

      I'm working with ASP vbscript with SQLServer 2005

      Does anyone have any ideas what is going on and hopefully a remedy?

      Many thanks

      Justin