How Can I Determine Username on Delphi Interbase DB?

Posted on 2009-02-10
Last Modified: 2013-12-09
I have a collection of database files which were embedded in an executable that I have determined to be written in Delphi 7 (I ran DeDe on it.) What I want to do is be able to write an app that can read these database files and do reports. I do not have the source code. Is it possible to:
1. determine if they are, in fact, Interbase files;
2. find out the username and password for these files?

Also, what is the best way to connect to this database from Visual Studio 2005?
Question by:rkulp
    LVL 1

    Author Comment

    I failed to mention that the files are located on the local host. Also, I found this posting after submitting my question. It suggests a provider:

    I still need to be able to determine the username and password, if any.
    LVL 4

    Accepted Solution

    On Firebird there is no users nor passwords to database file. These data are stored on server side, so if you will install Firebird then you will have one default user SYSDBA with password masterkey, which you can use to connect to any database throught this FB server.
    Firebird is based on Interbase so I suppose this should work for Interbase too.
    LVL 1

    Author Comment


    I think you are correct. Unfortunately, I tried it with the IBProvider and got an error message that the file was not a valid database. So, this seems to answer the first question and leads to the question: What kind of database is it? There is a cdx file for each of the udb files. The same structure is in another folder where all the files are sdb. The first letter of the extension matches the first letter of the folder name. I don't think the extension follows any of the standard default extensions.
    I will accept this answer but would appreciate any suggestions you have about detecting the true db. Thanks for your quick response.
    LVL 4

    Expert Comment

    Don't give up so quickly :)
    Check on which version of Interbase or Firebird did you try to connect, because in FB for example, you won't connect to database created/restored by FB 2.x using FB1.x. It might be similar in Interbase

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Join & Write a Comment

    Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now