Thanks to all! DBA is the name of an actual MRP/ERP software that was purchased by my employer. We installed it, but he doesn't like the reports available (at least some of them) and wants to have some different ones. DBA themselves won't respond, so he wants to be able to have me access the database directly to write a couple of queries to massage his data.

I'll try to find the DB with the information given by all of you. Perhaps I won't be able to write my own queries with firebird. Oh, well, back to MS SQL Server. Darn!





-- In firebird-support@yahoogroups.com, Alexandre Benson Smith <iblist@...> wrote:

>
> dgrblr wrote:
> > how can I find the actual location of, and the actual database for Firebird?
> >
> > 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?
> >
> > I want to get to the database tables in order to do some custom SQL queries for trials.
> >
> > Thanks again!
> >
>
> Firebird has no mandatory extension, usually developers uses .fdb or
> .gdb, but it can be anything.
>
> I suggest you to use FileMon/ProcMon/ProcExp from SysInternals, and look
> for Open Files/Handles and see what it's using.
>
> Anyway, you will need to know a user password to access the data, will
> not enter in details how you could bypass it, but I think your best
> option is to contact the software developer to know the file location,
> Firebird Version, Login/Password.
>
> see you !
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>