Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.