Re: Re: [sqlite] Detached database still owned by process

2006-11-29 Thread Anders Holmberg
Thanks for the responses. The ProcessExplorer was just the thing I needed! With it I can see that sqlite _does_ release the file handle and that my program must hold on to it in another way sometimes. Now I have to find that sometime;) Thanks again... /Anders --

Re: [sqlite] Detached database still owned by process

2006-11-29 Thread Trevor Talbot
Sysinternals' Process Explorer can be used to verify that your process does indeed still have a handle to the file, or search for another process that does, if you need it. http://www.microsoft.com/technet/sysinternals/ProcessesAndThreads/ProcessExplorer.mspx In the .NET application case, make s

Re: [sqlite] Detached database still owned by process

2006-11-29 Thread Jay Sprenkle
I've had this same issue with files written by .net applications. I haven't found what's causing mine yet... It might help to wait 10 seconds or so and retry the operation On 11/29/06, Anders Holmberg <[EMAIL PROTECTED]> wrote: Hi I am using sqlite (version 3.3.7) on Windows and I am loading on

Re: [sqlite] Detached database still owned by process

2006-11-29 Thread drh
"Anders Holmberg" <[EMAIL PROTECTED]> wrote: > Hi > > I am using sqlite (version 3.3.7) on Windows and I am loading one database > (stored in a file) into another database (:memory:) using the attach / > detatch scheme described on the sqlite site. > > My problem is that sqlite keeps hanging on t