how to connect to firebird DB and change a value?

Posted on 2009-12-22
Last Modified: 2013-12-09
i have an old system that i never touched and now need to make a change to the tax table.

all i know at this point is the information is housed in a fire bird DB. does anyone know of a client like MS SQL management studio i can use to connect to the firebird DB and ten brows the tables and records?

or list a series of steps i need to follow to get this  done.

i found the .fdb file on the C drive and need to know how to play with it now.

Question by:supergirl2008
    LVL 13

    Accepted Solution

    Yes there are several tools as found here:

    I use IBExpert the free version...


    Author Comment

    made some headway and got this error.

    something about being denied access by server administrator.

    any ideas about this?
    LVL 13

    Expert Comment

    hmmm try to get the exact error message, but that's strange, if you have the username and password for the database that's all you need
    LVL 13

    Assisted Solution

    The two programs that I've used are FlameRobin and IBAccess.  I've sometimes had problems getting FlameRobin to work correctly but when I got it to work, it worked well with the one exception of that it always complains about not finding an error message file, instead of giving error messages.  It uses the mouse for most things and you can accomplish quite a lot with just a few clicks.  IBAccess's user interface is unpolished but other than that it is very powerful.

    I'm guessing you just don't have the right password.  If you're lucky and they didn't care about security you could try the default user/password sysdba/masterkey.
    LVL 6

    Assisted Solution

    If you are getting SQLCODE = -902, then it is username and password, there are ways to bypass Firebird security and they are aware of it. But, first try SYSDBA and masterkey.


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Read about achieving the basic levels of HRIS security in the workplace.
    Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
    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…

    734 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

    24 Experts available now in Live!

    Get 1:1 Help Now