Subject | Re: [firebird-support] Database Location |
---|---|
Author | Helen Borrie |
Post date | 2009-07-15T23:56Z |
At 09:11 AM 16/07/2009, you wrote:
The server has no way to search your filesystem for database files. If you don't give it a filesystem path in the connection string, it won't know what to look for.
./heLen
>how can I find the actual location of, and the actual database for Firebird?Adding to what the others told you, Firebird is a server that can manage multiple databases. Each database lives in its own file. ".fdb" is the recommended suffix to use for helping humans to identify a Firebird database. As far as the server knows or cares, the suffix could be anything, including none at all.
The server has no way to search your filesystem for database files. If you don't give it a filesystem path in the connection string, it won't know what to look for.
>It was installed as a part of DBA software, and I don't know the extension used in order to do a search. Perhaps some help with names, extensions, etc. would work for me?You *could* look at the text file aliases.conf, in your Firebird root directory. If the developer has made use of the database file aliasing feature, you would find the paths to databases there.
>I want to get to the database tables in order to do some custom SQL queries for trials.Definitely go to the vendor for instructions, perhaps even permission. It is actually quite common for vendors of commercial software to go to amazing lengths to make it difficult to access their databases from external tools.
./heLen