jacqueleroux777;
Never used Interbase, but am slightly familiar with Firebird. In order to use Base with an Interbase *.gdb file would suggest the following (you will have to search out the download sources as I don't have them handy):
1) Download a Firebird installer - I KNOW that vers 2.1.1 will work with Base as I am using it.
2) You may need to "convert" your *.gdb database file to a *.fdb - am not sure. I don't think so but could be mistaken. In any event I know I've read stuff in the Firebird documentation on this. I would suggest using the *.gdb first and if not work, then study up on the conversion.
3) You need the Java runtime environment - I think that gets installed with OpenOffice.Org itself.
4) download a zipped file Jaybird.2.2.0snapshot_20060810JDK_1.5. Unzip (extract) the file. This has "fixes" for certain non standard/non compliant issues in Base.
5) In Open Office tools->options->Java first be sure there is a Java runtime environment installed (mine shows Sun Microsystems Inc version 1.6.0_07. Then click on class path.
6) Navigate to the file Jaybird-full-2.2.0 and click on it. This will then show up in Open Office as a class library.
7) Open a dateabase in Open Office, click on connect to existing database, using JDBC
8) The driver name to enter is org.firebirdsql.jdbc.FBDriver
9) the URL to enter (after the jdbc:) is firebirdsql:oo: <computer name where data file is located>:c:\<path to database and database name> [you'll have to insert yours]
10) During the above process click on the "test driver" and then on the "test connection". They should check out if you've typed everything ok. If the *.gdb database cannot be read, you will need to convert you file to a *.fdb.
11) Once you make you connection, you can edit, create forms, reports etc. in Base to access, change etc. your Interbase/Firebird files.
The above does work, I know. Good luck.
John
