RE: [libreoffice-users] Re: Connect ODBC / JDBC Firebird database - LibreOffice 3.3.3 - Windows XP

Hi, Alex!

Thank you very much. I did what you said and all is OK.

Since the Firebird server is on Windows, the string to connect is:

firebirdsql:servername/3050:C:\\FOLDER\\DATABASE.FDB

Thank you again.

GIOVANNI ROMERO PÉREZ

-----Mensaje original-----
De: Alexander Thurgood [mailto:alex.thurgood@gmail.com] 
Enviado el: Jueves, 28 de Julio de 2011 05:17 a.m.
Para: users@global.libreoffice.org
Asunto: [libreoffice-users] Re: Connect ODBC / JDBC Firebird database -
LibreOffice 3.3.3 - Windows XP

Le 28/07/11 01:14, Giovanni Romero Pérez a écrit :

Hi Giovanni,


> Then I created a database in Base and did the settings to connect to the
> database using the ODBC source. The connection is OK, but when I try to
> Access to a table or run a query, Base throws this message:
>
> --------------------------------------------------
> No se pudieron cargar los contenidos de los datos.
> Fetch type out of range
> --------------------------------------------------
>
> And I can not see the results.

> From what I remember of other people's attempts to connect using ODBC,
this is currently not working with LibreOffice (or even OpenOffice.org
for that matter).

> I thought about using JDBC, as I have read that allows you to connect more
> easily. The problem is that I don't find documentation to configuring
> Firebird JDBC connector (called Jaybird and available at
> http://www.firebirdsql.org/en/jdbc-driver).

You have to first declare the JDBC JAR within LibreOffice so that it
knows where to look to find it.

1) Menu Tools - Options - LibreOffice - Java

wait for it to detect your Java installation(s), select the one that you
want as required (if you have a choice).

2) Click on the button "Classpath", then on the button "Add archive".

3) Navigate using the file picker dialog to where your JAR file is
located, select it, then click on OK. It should then appear in the list
of added java archives.

4) Click on OK to quit the Java configuration dialog.

5) Shut down LibreOffice, including any quickstarter (icon in the tray
at the bottom right of your screen)

6) Restart LibreOffice

7) Click on File - New - Database

8) Choose "Connect to an existing Database" and select "JDBC" from the
driver selection list.

9) In the JDBC setup fields :

Datasource URL :
firebirdsql://servername:port//path/to/db/location/dbname.fdb

JDBC driver class : org.firebirdsql.jdbc.FBDriver


Note that these last two parameters I obtained from this page :

http://www.insttech.washington.edu/~lab/Support/HowtoUse/UsingJDBCWithFirebi
rd.html

I don't actually have a firebird server running to be able to test.



Alex




-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted


-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted