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?'
-
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 (10.72 KiB) Viewed 8893 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!