Page 1 of 1

LC and Libreoffice Base

Posted: Wed Feb 19, 2020 12:12 am
by TWHKNUT
Has anyone tried to connect a LiveCode card(s) to a Libreoffice / OpenOffice database If yes, examples would be fantastic

Re: LC and Libreoffice Base

Posted: Wed Feb 19, 2020 10:41 am
by richmond62
What, exactly, do you mean by a "LibreOffice/OpenOffice database"?

Surely the question should be:

'Have you managed to connect to a Firebird Embedded or an HSQLDB Embedded database?'
-
Screenshot 2020-02-19 at 11.38.25.png

Re: LC and Libreoffice Base

Posted: Wed Feb 19, 2020 10:53 am
by AxWald
Hi,

there's a FireBird ODBC driver (for Win, at least). This may work.

Have fun!

Re: LC and Libreoffice Base

Posted: Wed Feb 19, 2020 3:46 pm
by TWHKNUT
richmond62: you are absolutely correct, my question should have been can LC connect to a HSQLDB embedded data base. So, does anyone know if it can ? The "Firebird Embedded" is not listed as a option in my Linux version of Linux Mint

Re: LC and Libreoffice Base

Posted: Wed Feb 19, 2020 4:13 pm
by richmond62
Well . . .

RevOpenDataBase
can connect to a MySQL, SQLite, PostgreSQL, ODBC or Oracle database.

I wonder . . .
-
Screenshot 2020-02-19 at 17.12.12.png
Screenshot 2020-02-19 at 17.12.12.png (10.72 KiB) Viewed 2459 times

Re: LC and Libreoffice Base

Posted: Thu Feb 20, 2020 1:27 am
by TWHKNUT
raymond62, based on your screen shot it look like you tried to connect to a HSQLDB (Libreoffice Base ie .odb) database .... any success ?? Also, AxWald mentioned a "driver", would that be a OS (Linux Driver ??), if so, wouldn't it already be there since LO Base uses it.

Re: LC and Libreoffice Base

Posted: Thu Feb 20, 2020 10:42 am
by bogs
ODBC stands for "Open Data Base Connectivity". The link explains it pretty well, including what a driver is.

I'm a little curious as to what you are looking to access db's made in Libre Office specifically to begin with, instead of say, just making your own db's from within Lc.

As to connecting to an ODBC db, it is certainly possible to do from Lc. That link includes examples of how it is done, which you can test to see if they work with Libre Offices flat file dbs.

Re: LC and Libreoffice Base

Posted: Thu Feb 20, 2020 11:23 am
by richmond62
Who is 'raymond62' ?

Re: LC and Libreoffice Base

Posted: Thu Feb 20, 2020 11:25 am
by richmond62
I'm a little curious as to what you are looking to access db's made in Libre Office specifically to begin with, instead of say, just making your own db's from within Lc.
I would jalouse that the OP is being sent a db made in Libre Office that s/he wants to extract data from . . .

Re: LC and Libreoffice Base

Posted: Thu Feb 20, 2020 11:26 am
by AxWald
Hi,
TWHKNUT wrote:
Wed Feb 19, 2020 3:46 pm
[...] my question should have been can LC connect to a HSQLDB embedded data base. [...] my Linux version of Linux Mint
Ooops, I missed this. A search for "HSQLDB ODBC" gave me this.
HSQLDB seems to be PostgreSQL related, have you tried to connect via 'revOpenDatabase("postgresql", ...'?

Have fun!