LC and Libreoffice Base

[TWHKNUT]

Has anyone tried to connect a LiveCode card(s) to a Libreoffice / OpenOffice database If yes, examples would be fantastic

[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?'
-

[AxWald]

Hi,

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

Have fun!

[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

[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 27720 times

[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.

[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.

[richmond62]

Who is 'raymond62' ?

[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 . . .

[AxWald]

Hi,

[...] 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!