Subject | Re: Overwrite existing dtabase file when creating database |
---|---|
Author | georgeyod |
Post date | 2007-01-13T23:56:37Z |
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...>
wrote:
wrote:
>file
> At 01:54 AM 14/01/2007, you wrote:
> >I'm using windows xp,visual studio 2005, embeded version 1.5.3 and
> >receive the following error when trying to create a new database
> >using overwrite set to TRUE to overwrite a previously createddatabase
> >file.True)
> >
> >here is my code:
> >
> >FbConnection.CreateDatabase(DBConnectionBuilder.ConnectionString,
> >doesnt
> >
> >This is the error message:
> >
> >I/O error for CreateFile(create) "<filename>"
> >Error while trying to create file
> >
> >
> >It creates a new database file without any problems if the file
> >exist.without
> >
> >any help or suggestions would be greatly appreciated.
>
> This sounds like exactly the correct behaviour. By design, the
> underlying -r[eplace_database] switch is disallowed if the
> authenticated user is not the owner of the database or the SYSDBA
> user. Since the embedded server connects its embedded client
> authentication, the "user" is no user at all at the point wherethis
> client makes its DROP DATABASE request and, fortunately, it fails.thanks for replying. point well taken.
>
> As a matter of pure curiosity, have you considered the implications
> of trying to design an embedded application that has the capability
> to disembowel itself?
>
> ./heLen
>