LC and Libreoffice Base

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
TWHKNUT
Posts: 7
Joined: Tue Feb 18, 2020 5:59 pm

LC and Libreoffice Base

Post by TWHKNUT » Wed Feb 19, 2020 12:12 am

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

richmond62
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 9250
Joined: Fri Feb 19, 2010 10:17 am
Location: Bulgaria

Re: LC and Libreoffice Base

Post by richmond62 » Wed Feb 19, 2020 10:41 am

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

AxWald
Posts: 578
Joined: Thu Mar 06, 2014 2:57 pm

Re: LC and Libreoffice Base

Post by AxWald » Wed Feb 19, 2020 10:53 am

Hi,

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

Have fun!
All code published by me here was created with Community Editions of LC (thus is GPLv3).
If you use it in closed source projects, or for the Apple AppStore, or with XCode
you'll violate some license terms - read your relevant EULAs & Licenses!

TWHKNUT
Posts: 7
Joined: Tue Feb 18, 2020 5:59 pm

Re: LC and Libreoffice Base

Post by TWHKNUT » Wed Feb 19, 2020 3:46 pm

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
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 9250
Joined: Fri Feb 19, 2010 10:17 am
Location: Bulgaria

Re: LC and Libreoffice Base

Post by richmond62 » Wed Feb 19, 2020 4:13 pm

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 8856 times

TWHKNUT
Posts: 7
Joined: Tue Feb 18, 2020 5:59 pm

Re: LC and Libreoffice Base

Post by TWHKNUT » Thu Feb 20, 2020 1:27 am

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
Posts: 5435
Joined: Sat Feb 25, 2017 10:45 pm

Re: LC and Libreoffice Base

Post by bogs » Thu Feb 20, 2020 10:42 am

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

richmond62
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 9250
Joined: Fri Feb 19, 2010 10:17 am
Location: Bulgaria

Re: LC and Libreoffice Base

Post by richmond62 » Thu Feb 20, 2020 11:23 am

Who is 'raymond62' ?

richmond62
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 9250
Joined: Fri Feb 19, 2010 10:17 am
Location: Bulgaria

Re: LC and Libreoffice Base

Post by richmond62 » Thu Feb 20, 2020 11:25 am

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
Posts: 578
Joined: Thu Mar 06, 2014 2:57 pm

Re: LC and Libreoffice Base

Post by AxWald » Thu Feb 20, 2020 11:26 am

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!
All code published by me here was created with Community Editions of LC (thus is GPLv3).
If you use it in closed source projects, or for the Apple AppStore, or with XCode
you'll violate some license terms - read your relevant EULAs & Licenses!

Post Reply

Return to “Databases”