Subject Re: [firebird-support] Using Firebird SuperClassic and Embedded (SC) v2.5 on same server
Author Carlos H. Cantu
LS> Although we deploy standard server installs, there are times when
LS> we need to ensure that no external connections (ODBC) can connect
LS> to local databases while we perform database maintenance.

Can't you just put the database in "single shutdown" mode before doing
the maintenance?

PS: I'm assuming your "normal" user doesn't connect to the database as
SYSDBA/OWNER.

LS> Deploy standard server installs, but also deploy embedded DLL
LS> into application folder for our maintenance tool.
LS> So, our deployment approach would be:
LS> - stop the Firebird server
LS> - perform the maintenance using DB tool,
LS> - restart Firebird,
LS> Questions:
LS> - is the above possible?
LS> - If so, are there any gotchas that I need to be aware of?

Other apps using an embedded engine would also be able to connect to
the database during the maintenance. Not a problem if you are sure
that no such apps exists, but you know Murphy...

[]s
Carlos
Firebird Performance in Detail - http://videos.firebirddevelopersday.com
www.firebirdnews.org - www.FireBase.com.br