Base as ODBC source
Base as ODBC source
Is there available an Base ODBC driver?
I would like to create an ODBC data source and maintain data in Base table.
I would like to create an ODBC data source and maintain data in Base table.
-
- Volunteer
- Posts: 283
- Joined: Tue Dec 04, 2007 6:38 pm
- Location: Houston, TX
Re: Base as ODBC source
to my knowledge you can not. only ODBC--> Base; not Base-->ODBC
Re: Base as ODBC source
A little update
Is there any API to get data from Base table (JDBC,ODBC,OLEDB....)????
Is there any API to get data from Base table (JDBC,ODBC,OLEDB....)????
Re: Base as ODBC source
Only way, If you could write a code to extract HSQL database from odb file you could connect to HSQL JDBC driver in memory, after closing, repack it right.
I never tried.
You could find some code:
http://digiassn.blogspot.com/2006/07/ja ... on-to.html
I never tried.
You could find some code:
http://digiassn.blogspot.com/2006/07/ja ... on-to.html
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Hungarian forum co-admin
- DrewJensen
- Volunteer
- Posts: 1734
- Joined: Sat Oct 06, 2007 9:01 pm
- Location: Cumberland, MD - USA
Re: Base as ODBC source
There is no such interface for an embedded Base database. There is the API within OpenOffice.org that can be called from another programming language of course, but no such ODBC or OLEDB style driver.
If interoperability of this type is required however you can simply use an external data storage engine for your Base database, and then access this using which ever platform is appropriate, when appropriate.
If interoperability of this type is required however you can simply use an external data storage engine for your Base database, and then access this using which ever platform is appropriate, when appropriate.
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
-
- Posts: 2
- Joined: Tue Oct 13, 2009 11:20 pm
Re: Base as ODBC source
Hi Everyone,
I see the last post to this thread was back in late 2007... about two years ago. One never knows how much things might change in that time, so I thought I would ask the question again...
That is, has anyone yet developed an ODBC driver so that Base can itself function as an ODBC source? It seems to me a DB is truly useful only if it's data is/are available to outside front-end software. Don't get me wrong... I'm not being the least bit critical. I'd write a driver myself were I not a complete dummy.
Rather I am just wondering if someone has yet developed a driver for this great DB product.
Many thanks to all who read/respond.
RJ
I see the last post to this thread was back in late 2007... about two years ago. One never knows how much things might change in that time, so I thought I would ask the question again...
That is, has anyone yet developed an ODBC driver so that Base can itself function as an ODBC source? It seems to me a DB is truly useful only if it's data is/are available to outside front-end software. Don't get me wrong... I'm not being the least bit critical. I'd write a driver myself were I not a complete dummy.
Rather I am just wondering if someone has yet developed a driver for this great DB product.
Many thanks to all who read/respond.
RJ
Open Office 3.1.1
Vista Ultimate
Vista Ultimate
Re: Base as ODBC source
I bet you do not use Base. It is far from being a "great DB product". It is not even a database on its own right. Base is a bridge between databases and office documents.Rather I am just wondering if someone has yet developed a driver for this great DB product.
http://hsqldb.org is the type of database which can be wrapped into a "base document" which is hardly more than XML-configuration in a zip-archive. http://hsqldb.org is accessible via JDBC rather than ODBC.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Base as ODBC source
I think you'd be better off using Base as a front end (which is all it is) to another database such as MySQL (which already supports ODBC).
The actual database engine that gets bundeled with OOo is HSQLDB, and the 'databases' it creates are all OOo documents with the data etc inside them. So I think it is HSQLDB that would need to support ODBC, which is (apparently) in development by the HSQLDB guys.
The actual database engine that gets bundeled with OOo is HSQLDB, and the 'databases' it creates are all OOo documents with the data etc inside them. So I think it is HSQLDB that would need to support ODBC, which is (apparently) in development by the HSQLDB guys.
Ubuntu 14.10 Utopic Unicorn, LibreOffice Version: 4.3.3.2
Gurkha Welfare Trust
Gurkha Welfare Trust
-
- Posts: 2
- Joined: Tue Oct 13, 2009 11:20 pm
Re: Base as ODBC source
Thanks TheGurkha for that clarification. I went to the link you provided at http://hsqldb.org/ and did some reading. I think you are right in that any hope of finding an ODBC driver (more likely JDBC) would be found there.
Thanks again!
RJ
Thanks again!
RJ
Open Office 3.1.1
Vista Ultimate
Vista Ultimate
Re: Base as ODBC source
No ODBC or JDBC driver for OOo Base odb file. No plans for creation such drivers.
OOo Base designed and remains single file, single user application.
OOo base can be applied to connect external data sources as Villeroy and TheGurka says.
Workaround: As described in link on my earlier post.
Open odb file with zipper, extract database script and data, start HSQLDB server, connect to HSQLDB with JDBC connection, manipulate data, stop server, save back script and all data into odb file.
OOo Base designed and remains single file, single user application.
OOo base can be applied to connect external data sources as Villeroy and TheGurka says.
Workaround: As described in link on my earlier post.
Open odb file with zipper, extract database script and data, start HSQLDB server, connect to HSQLDB with JDBC connection, manipulate data, stop server, save back script and all data into odb file.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Hungarian forum co-admin