×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Firebird data extract

Firebird data extract

Firebird data extract

(OP)
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
It's never too early to begin preparing for 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

RE: Firebird data extract

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

RE: Firebird data extract

(OP)
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
It's never too early to begin preparing for 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

RE: Firebird data extract

"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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close