Subject Re: [firebird-support] Re: File in use
Author Helen Borrie
At 06:34 AM 12/02/2005 +0000, you wrote:

>That makes sense. How does this logic apply to the embedded
>version? I should have specified in my first post that I was using
>the firebird embedded database.

No different. The embedded version is just a single-user instance of client
and SuperServer.


>In specific, I'm using the ADO.Net provider and the fbembed.dll.
>It is also worth noting that I've tried to use the
>FbConnection.DropDatabase() method by issuing the same list of
>parameters that I used to create the database

SQL doesn't support that. I don't know what the .net provider surfaces
there. The proper place to ask about that would be the
firebird-net-provider list.

>and I receive the following message:
>
>"lock-timeout on wait transaction"

Goodness only knows. (Well, Carlos, SeƱor Net-Provider, should be able to
tell you what he's doing under the hood there, for Carlos is Goodness in
Blue Jeans!).

On appearances, I'd guess that there is a transaction running there that
has to be finished (committed or rolled back) before the server is going to
let you demolish the database.

./hb