[thelist] ASP: residual database files

Michael K. Ahn mike at ahnfire.com
Fri Jul 19 13:28:12 CDT 2002


Make sure you set your connection to nothing, as well as closing it.

Ie:
If objConnection.State = adStateOpen Then
   objConnection.Close
End If
Set objConnection = Nothing

Although maybe it has something to do with connection pooling or system
dsn keeping it open?

Michael

> -----Original Message-----
> From: Jay Blanchard [mailto:jay.blanchard at niicommunications.com]
> Sent: Friday, July 19, 2002 2:25 PM
> To: thelist at lists.evolt.org
> Subject: RE: [thelist] ASP: residual database files
>
> --
> [snip]
> once i access (just about) any page on a site i'm working on i notice
> that there are files with the extension .ldb lying around.
>
> i think it's like a temp file or something, but they don't go away. i
> looked through the code and thought that it might be because i am not
> closing a connection to the db, but it looks like everything is being
> closed.
>
> am i not looking hard enough, or is it something else?
> [/snip]
>
> They are database log files created by the M$ system you are using.
One a
> DB
> has a log another does not get created for it. Can you remove them?
Use
> extreme caution, making sure that the DB is not in use at the moment.
If
> it
> is you will suffer some untold horror. :^]
>
> Jay
>
> "Santa is jolly because he knows where all the bad girls live"
>
> *************************************
> * Want to meet other PHP developers *
> * in your area? Check out:          *
> * http://php.meetup.com/            *
> * No developer is an island ...     *
> *************************************
> --
> [ winmail.dat was deleted, please don't send attachments with your
> message. ]
> --
>
>
> --
> For unsubscribe and other options, including
> the Tip Harvester and archive of thelist go to:
> http://lists.evolt.org Workers of the Web, evolt !



More information about the thelist mailing list