Close connection error??

Results 1 to 6 of 6

Thread: Close connection error??

  1. #1
    Join Date
    Dec 1969

    Default Close connection error??

    anyone know why I get an error when i try close the recordset here??<BR>I have tried just setting the recordset to nothing but that also give me an error??<BR>Using sql server 7<BR><BR>SQl = "UPDATE Venue SET Venue.Name =&#039;" & Request.Form("Name") & "&#039;, Venue.Phone =&#039;" & Request.Form("Phone") & "&#039;"<BR><BR>rsSave.Open SQL, objConnection, ,adLockOptimistic<BR>rsSave.Close<BR>Set rsSave = Nothing

  2. #2
    Ed Guest

    Default Already closed...

    You can&#039;t set it to Nothing if it&#039;s closed... Are you getting the error on the SET = Nothing line?

  3. #3
    Join Date
    Dec 1969
    Los Angeles, CA

    Default Post the error message <eop>


  4. #4
    Join Date
    Dec 1969

    Default RE: Close connection error??

    I think on an update the recordset only executes. I don&#039;t believe it stays open, just remove that close line and nothing line.

  5. #5
    Join Date
    Dec 1969

    Default Yeah..

    when u execute action queries (insert and update/delete)with recordeset object, u don&#039;t have anything in recordset once it is executed.Though not dealt with earlier, i too think this is the reason.<BR><BR>

  6. #6
    Medieval Dude Guest

    Default RE: Already closed...

    Yes you can. There&#039;s nothing wrong with setting something to nothing after closing it. I do it all the time.

Posting Permissions

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