Do I need to close my connection?

Results 1 to 3 of 3

Thread: Do I need to close my connection?

  1. #1
    DBQ Guest

    Default Do I need to close my connection?

    I open my database with this syntax:<BR> SET cn = Server.CreateObject("ADODB.Connection")<BR> cn.Open "TMP"<BR><BR>Do I need to close my database each time I open it with syntax like this? This same code is used throughout my program about 4 times.

  2. #2
    Join Date
    Dec 1969

    Default YES

    you should always close any open connections after you have finished with them<BR><BR>recordset and database, its just good practice

  3. #3
    DBQ Guest

    Default Will another connection cause an error?

    If I open another connection to this same database while the first connection is still open, will this cause an error?

Posting Permissions

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