Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003

    Unanswered: Can you open a recordset adOpenDynamic from a stored procedure?


    Just having problems opening a recordset based on sproc that doesn't open forward-only.

    Originally tried Command.Execute but this always returns a recordset in forward-only mode. So i tried...

    Dim rs As New ADODB.Recordset
    rs.Open "csptgCA_Options ""CA_SubjectVersionDetails"", 0", db, adOpenDynamic, adLockReadOnly

    But it still opens it with cursor type of forward-only!

    Does anyone know how to do this?


  2. #2
    Join Date
    Mar 2004

    Re: Can you open a recordset adOpenDynamic from a stored procedure?

    If a provider does not support the requested cursor type, it may return another cursor type. The CursorType property will change to match the actual cursor type in use when the Recordset object is open. To verify specific functionality of the returned cursor, use the Supports method.

    Try adOpenStatic instead of dynamic and see if that works.

    Download for FREE the ADO/DAO Data Controls that makes life EASIER developing database applications in: VB, FoxPro, Access, VC++, .NET etc... Navigate, Add New, Delete, Update, Search, Undo and Save your changes. Supports Disconnected Recordsets and Transactions!

    Or try our Ask An Expert service to answer any of your questions!

Posting Permissions

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