Subject AW: [firebird-support] Re: how to run embedded firebird in a CD in readonly mode.
Author Thomas Rueger
Hello Helen,

i'm proud that i can give you some information back, for all the help from
you .... ;-)

Okay, how to run embedded from CD:


I'm using Firebird RC 7, Visual Basic 6 SP 5 for
For my user i made a Single Version with embedded and an intranet version
with Firebird Server ... works fine..

On my website i have a version for testing, but that wasn't my target,
because the user have to install.

Now i followed the thread and here is my solution (tested now under Windows
NT SP 4 and Windows 2k SP 3)

changed the database with gfix -mode read_only -user sysdba -password
YourPassword to readonly

Changed the connection string in Visual Basic to mode read_only too.

Used only Select Statements, no generators or sp in my program/database

Copy all the stuff on a CD and it works

Ciao Thomas

(Come from Germany, that's the reason for bad english, sorry)

-----Ursprungliche Nachricht-----
Von: Helen Borrie [mailto:helebor@...]
Gesendet: Mittwoch, 11. Februar 2004 12:54
Betreff: Re: [firebird-support] Re: how to run embedded firebird in a CD
in readonly mode.

At 11:39 AM 11/02/2004 +0000, robert_hollay wrote:
>But is it possible to make a "true" read only embedded server
>installation on a CD? I mean, all the stuff on one CD (not only
>the database, but the server too).
>Can security.fdb be read only?

When it's used, the security.fdb can't be read-only - but the Windows
Embedded Server doesn't use it.

But I don't think you could make a whole embedded app that runs off a CD,
because the OS has to put an exclusive lock on the database file. I think
you'd have to have the application + client as an installable app on the
host machine, with a routine to create the database alias to point to the
location of the database on the CD-Rom drive.

I set up an embedded server app + read-only database on flash drive. That
worked fine, because it's a read-write device, so no problem with the
exclusive lock.


>--- In, Helen Borrie <helebor@t...>
> > At 06:52 AM 11/02/2004 +0000, you wrote:
> >
> > Yes.
> >
> > You actually have to make it a read-only database *before* you copy
>it to
> > the CD.
> > Either
> > restore it from a backup with the -mode read_only switch
> >
> > or
> > use gfix:
> >
> > gfix -mode read_only /path/to/your/database
> >
> > heLen
> > >
>Yahoo! Groups Links

[Non-text portions of this message have been removed]