• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 647
  • Last Modified:

how to connect to firebird DB and change a value?

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.

3 Solutions
Yes there are several tools as found here:

I use IBExpert the free version...

supergirl2008Author Commented:
made some headway and got this error.

something about being denied access by server administrator.

any ideas about this?
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
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.
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now