Subject Re: [firebird-support] Can you get firebird to check a database existence ?
Author Daniel Rail
Hi,

At September 27, 2004, 23:26, Craig Stevens wrote:

> Can firebird do something similar to delphi's FileExist function
> given only the database Alias name ???

> I have a need to confirm a restored database works by testing to
> see if the restore db exists, but given only an aliasname it seems
> not possible, but im sure it is..if Firebird restores the db to the
> path as per the aliases.conf file, how can i obtain t
> his path from the alias ?? is there a function i am not aware of ???

The simplest way I can think of would be to try to connect to the
database. And, if the connection fails, look at the error message and
error number. If the database file can't be found, usually the error
message will indicate that. Have you already tried to connect to a DB
via an alias where the corresponding db file doesn't exists?

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)