Problem with disconnecting recordset

Results 1 to 2 of 2

Thread: Problem with disconnecting recordset

  1. #1
    Join Date
    Dec 1969

    Default Problem with disconnecting recordset

    Hi All,<BR><BR>I have a question in regards to disconnecting a recordset.<BR><BR>The code is as follows;<BR><BR>Dim [Recordset]<BR>Set [Recordset] = Server.CreateObject("ADODB.recordset")<BR>[Recordset].CursorLocation = adUseClient<BR><BR>Set [Recordset] = [Connection].Execute([Stored Procedure])<BR>[Recordset] .ActiveConnection = Nothing<BR><BR>I am getting the error:<BR><BR>ADODB.Recordset error &#039;800a0e79&#039; <BR>Operation is not allowed when the object is open. <BR><BR>If I open the recordset with the SQL statement in the stored procedure I can disconnect the recordset, it appears that when I use SET [recordset] = xxx I have the problem.<BR><BR>Is this a limitation or am I doing something wrong?!<BR><BR>Any advice appreciated!<BR>

  2. #2
    Join Date
    Dec 1969

    Default It is a limitation


Posting Permissions

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