Closing a database (getting rid of the ldb)

Results 1 to 2 of 2

Thread: Closing a database (getting rid of the ldb)

  1. #1
    Sergio Garcia Guest

    Default Closing a database (getting rid of the ldb)

    I use the global.asa file to create and open the only database connection I use. I use a session variable to pass the connection variable on. Whenever I close the database with:<BR><BR>Conn.close<BR>Set Conn=Nothing<BR><BR>it will not get rid of the ldb, telling me that the database is still open. Also, I close the recordset before running the database closing snippet. Does anyone have any better ideas on getting rid of the ldb. Thanks in advance.

  2. #2
    Join Date
    Dec 1969

    Default RE: Closing a database (getting rid of the ldb)

    I have read several articals that say it is not good putting your database connection in the Global.asa. All my ASP pages that i build open and close the connection in each page. it is more work, but i don&#039t have any problems with the record locking file .ldb. hope this helps<BR>

Posting Permissions

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