LC and Libreoffice Base
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
LC and Libreoffice Base
Has anyone tried to connect a LiveCode card(s) to a Libreoffice / OpenOffice database If yes, examples would be fantastic
-
- Livecode Opensource Backer
- Posts: 9454
- Joined: Fri Feb 19, 2010 10:17 am
- Location: Bulgaria
Re: LC and Libreoffice Base
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?'
-
Surely the question should be:
'Have you managed to connect to a Firebird Embedded or an HSQLDB Embedded database?'
-
Re: LC and Libreoffice Base
Hi,
there's a FireBird ODBC driver (for Win, at least). This may work.
Have fun!
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!
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!
Re: LC and Libreoffice Base
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
-
- Livecode Opensource Backer
- Posts: 9454
- Joined: Fri Feb 19, 2010 10:17 am
- Location: Bulgaria
Re: LC and Libreoffice Base
Well . . .
RevOpenDataBase can connect to a MySQL, SQLite, PostgreSQL, ODBC or Oracle database.
I wonder . . .
-
RevOpenDataBase can connect to a MySQL, SQLite, PostgreSQL, ODBC or Oracle database.
I wonder . . .
-
Re: LC and Libreoffice Base
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
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.
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.
-
- Livecode Opensource Backer
- Posts: 9454
- Joined: Fri Feb 19, 2010 10:17 am
- Location: Bulgaria
-
- Livecode Opensource Backer
- Posts: 9454
- Joined: Fri Feb 19, 2010 10:17 am
- Location: Bulgaria
Re: LC and Libreoffice Base
I would jalouse that the OP is being sent a db made in Libre Office that s/he wants to extract data from . . .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.
Re: LC and Libreoffice Base
Hi,
HSQLDB seems to be PostgreSQL related, have you tried to connect via 'revOpenDatabase("postgresql", ...'?
Have fun!
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!
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!