--- In firebird-support@yahoogroups.com, "Martijn Tonies" <m.tonies@...> wrote:

>
> Hello Larry,
>
> >> > I have a backup utility that needs to run with apps using embedded
> >> > server or client-server versions of Firebird.
> >> >
> >> > This utility needs to know if it's running embedded, so it won't run
> >> > svc->Shutdown().
> >> >
> >> > I don't see a column in a system table that will tell me if I'm
> >> > running
> >> > an embedded server or a client-server version of Firebird.
> >> >
> >> > How can this utility know the server type?
> >>
> >> Why do yu want to shut down the server anyway?
> >>
> >> Is it so you can safely copy the database file(s)?
> >>
> >> If so, I suggest a different approach:
> >> - run "gbak", or use the "Services API" of Firebird to create a Firebird
> >> backup
> >> - copy the resulting file
> >
> > Thanks Martijn:
> >
> > Oh CRAP!
> >
> > My typo. It's the recover utility, not the backup. Backup works fine
> > with either type of server.
> >
> > Sorry.
> >
> > The app does use the services API. I want to keep the recovery as
> > simple for the non-technical users I expect to be running the app, and
> > administering the database. So the app has a "Recover" button and a
> > dialog asking the location of the source of the recovery.
> >
>
> What does the recover functionality do?

Thanks again Martijn:

Here is the recover function. It's C++ using IBPP.

bool DATABASE_RECORD::recover_database(
const TCHAR *recover_database_filename,
HWND progress_window_handle,
DSM database_shutdown_mode,
int database_shutdown_timeout_seconds,
tstring *message_string_ptr)
{
bool error_found = false;
bool finished = false;
const char *wait_message_ptr = NULL;
DWORD file_attribute = 0;

try
{
// The user may not have a database.
if(database_id != NULL)
{
disconnect();
}

// This is directly from oliver.
IBPP::Service svc =
IBPP::ServiceFactory(db_server_name.c_str(),
db_user_name,
db_password);

svc->Connect();
file_attribute = GetFileAttributes(db_path_and_name.c_str());

if((file_attribute != INVALID_FILE_ATTRIBUTES) &&
((file_attribute & FILE_ATTRIBUTE_DIRECTORY) == 0))
{
// The file exists and isn't a directory.
svc->Shutdown(db_path_and_name,
database_shutdown_mode,
database_shutdown_timeout_seconds);

svc->StartRestore(string(recover_database_filename),
db_path_and_name, 8192,
IBPP::BRF(IBPP::brVerbose |
IBPP::brReplace |
IBPP::brPerTableCommit));

finished = false;
*message_string_ptr = TEXT("\n");

while(!finished)
{
wait_message_ptr = svc->WaitMsg();
finished = wait_message_ptr == NULL;

if(!finished)
{
< Write messages into a progress edit box.
}
}
}

// If we did shutdown, no restart is required
// as the DB has been restored
svc->Disconnect();
}

catch (IBPP::Exception& e)
{
< Some catch clause stuff. >
}

return !error_found;
}

I posted about this a while ago, and was told that I shouldn't do the svc->Shutdown() for apps using embedded Firebird.

This recovery function has been working with apps that use either embedded or client server Firebird, until tonight.

It stopped working on one app that runs only embedded Firebird, but it works on another that can use both, and works tonight on either.

The svc->Shutdown() threw an exception.

If I comment out the svc->Shutdown() for the app that was failing, the recovery works fine.

So I'd like to be able to test for an embedded database in the recovery function.

Thanks
Larry