Using OpenOffice with Firebird Database & JDBC

dsoneil

There is an excellent article (PDF) detailing how to connect OOo to the Firebird Open Source database via JDBC. It can be found at www.hexeon.ca or directly at: http://www.hexeon.ca/pdf/OOoFBvp.pdf

knowe · General User Joined: 26 Jan 2003 Posts: 30

This looks very useful. I don't know much about firebird but it seems to be gaining in popularity. Is JDBC the only supported way of connecting to a firebird database from OOo?

dsoneil · Posted: Fri Feb 28, 2003 12:06 pm Post subject: Other Connection Methods

I know that there are a couple of ODBC drivers available, some commercial some open source. The Open Source ODBC driver (found at www.ibpheonix.com) is not quite mature yet and has given me some headaches. The JDBC driver works very well and has a good news group for support.

Michael · Guest

Does anybody know, where this http://www.hexeon.ca/pdf/OOoFBvp.pdf document has gone?

Michael

Guest · Posted: Fri Oct 17, 2003 7:30 am Post subject: OOo & FB Doc

Hello,

The document can now be found here:

http://www.methyl.ca/pdf/OOoFBvp.pdf

I will be updating this document in the coming weeks to reflect the release of OOo 1.1 and Firebird 1.5 (once it's released). Also there is an updated JDBC driver.

If you have any suggestions or comments for the document please let me know.

Thanks,

Darcy O'Neil

GraemeWi · Posted: Sat Oct 18, 2003 1:29 pm Post subject:

I've experimented with OOo and Firebird via JDBC.

I could not get it working under my Win98 environment until i changed the \\ to / in the url.

So my datasource url became:

Guest · Posted: Wed Dec 10, 2003 7:09 am Post subject:

Guest · Posted: Thu Jun 17, 2004 1:21 am Post subject: Setup problem

Not sure if this list is still active, but I had some problems with this setup, I am using Windows XP, and I have Firebird running (I was able to connect using python, although I did not have much luck using SQuirreL as a client app).

After installing and adding the .jar fines to that classpath, I tried to add a new Data Source using JDBC, but it only wants to let me att a MySQL database.

Has anyone else seen this problem?

jobinau · Newbie Joined: 18 Apr 2008 Posts: 1 Location: Hyderabad

Connecting to Open Office from firebird is a cool stuff.
We can have either JDBC or ODBC. here is a tutorial prepared to show how to do that.
http://jobinau.googlepages.com/OOFB.htm[/url]
_________________
Regards,
Jobin