Firebird data extract

[MasterRacker]

I have an application that uses Firebird 2.0 as the DB on Windows.

Can anyone recommend a free GUI tool I could use to look at the table structure and do some querying with? Something like a free Crystal Reports would work. ( I see I can get a 30 day trial of Crystal, but that time window may not be long enough.)

Is there a way to wire Firebird to Access07? It looks like I could ODBC to individual tables but what if I don't know table names or even how many tables I have, relationships, etc?

Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]

 

[kjv1611]

When I saw FireBird, I first thought of FireFox, so I was thinking.... "FireBird does databases?" Obviously I've not dealt with that one.

Here's one option, if the free trial will get you by. Otherwise, it's a rather expensive product:

http://www.spectralcore.com/fullconvert/tutorials/convert-interbase-firebird-to-access.php

Well, this might also be an option, but it's using code. It is, however, free, best I can tell, as it's on sourceforge:

http://sourceforge.net/projects/fbdll4vb/

It says it's a "Firebird Direct Access for Visual Basic"

Depending upon the size of the database, you could create recordsets and snatch the data out to Access that way, using this plugin..

Here's a ShareWare app which might get what you want w/o Access or any other app. I don't know how much you can do with the free version:

http://firebird-data-wizard.smartcode.com/info.html

--

"If to err is human, then I must be some kind of human!" -Me

 

[MasterRacker]

For those who are interested: So far I've been able to get what I need from the applications built-in reporting tool but I did find this Interbase/Firebird IDE:

http://ibexpert.net/ibe/index.php?n=Main.DownloadFree

The completely free Personal Edition doesn't include the graphical query builder but it looks like you can still explore the tables. The full IDE looks like it could do whatever you want similar to SSMS.

Jeff
[small][purple]It's never too early to begin preparing for [/purple]International Talk Like a Pirate Day
"The software I buy sucks, The software I write sucks. It's time to give up and have a beer..." - Me[/small]

 

[biglebowski]

http://www.flamerobin.org/

 

[JarlH]

When I saw FireBird, I first thought of FireFox, so I was thinking.... "FireBird does databases?""

Actually Firefox was called Firebird for a while, like 6 or 7 years ago. But Firebird (db) forced them to change, and thats why its called Firefox today. (And first of all Firefox was called Phoenix. Still got a copy running on my Win 95 laptop!)

http://en.wikipedia.org/wiki/History_of_Mozilla_Firefox#Naming