Subject | Re: File in use |
---|---|
Author | kmesiab |
Post date | 2005-02-12T06:34:29Z |
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:
version? I should have specified in my first post that I was using
the firebird embedded database.
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 and I receive the
following message:
"lock-timeout on wait transaction"
Thanks for your replies.
-Kevin Mesiab
wrote:
> At 12:27 AM 12/02/2005 +0000, you wrote:rows
>
>
>
> >I'm trying to create a database then a table then insert a few
> >into the new table.deleted?
> >
> >All of that works, but if I try to delete the database file
> >afterwards, the file is in use by another process, how should I
> >effectively close out all activity so that the file can be
> >logical
> >Here is my process:
> >
> >Create database
> >Create connection
> >Create transaction
> >Create command
> >Run SQL
> >Commit transaction
> >Close connection
> >Dispose transaction
> >Dispose command
> >Dispose connection
>
> Firebird database isn't a series of file-driven objects, it's one
> file that is the campus of the server. The API doesn't physicallytouch
> the database file at all - it acts as a bearer of requests.Applications
> issue SQL commands to request the server to do things for you.issue a
>
> The proper way to delete a database is to connect to it and then
> DROP DATABASE command. You have to be SYSDBA or the databaseowner for
> this to succeed. Then, the server will do the necessaryfilesystem
> operations to delete the file.server has
>
> If you must, you can filesystem-delete the database once the
> been shut down and the client library is no longer loaded inserver memory.
>That makes sense. How does this logic apply to the embedded
> ./heLen
version? I should have specified in my first post that I was using
the firebird embedded database.
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 and I receive the
following message:
"lock-timeout on wait transaction"
Thanks for your replies.
-Kevin Mesiab