Base as ODBC source

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
tosiara
Posts: 2
Joined: Tue Dec 11, 2007 4:30 pm

Base as ODBC source

Post by tosiara »

Is there available an Base ODBC driver?

I would like to create an ODBC data source and maintain data in Base table.
QuazzieEvil
Volunteer
Posts: 283
Joined: Tue Dec 04, 2007 6:38 pm
Location: Houston, TX

Re: Base as ODBC source

Post by QuazzieEvil »

to my knowledge you can not. only ODBC--> Base; not Base-->ODBC
tosiara
Posts: 2
Joined: Tue Dec 11, 2007 4:30 pm

Re: Base as ODBC source

Post by tosiara »

A little update

Is there any API to get data from Base table (JDBC,ODBC,OLEDB....)????
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Base as ODBC source

Post by r4zoli »

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
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
User avatar
DrewJensen
Volunteer
Posts: 1734
Joined: Sat Oct 06, 2007 9:01 pm
Location: Cumberland, MD - USA

Re: Base as ODBC source

Post by DrewJensen »

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.
Former member of The Document Foundation
Former member of Apache OpenOffice PMC
LibreOffice on Ubuntu 18.04
coolblueice
Posts: 2
Joined: Tue Oct 13, 2009 11:20 pm

Re: Base as ODBC source

Post by coolblueice »

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. :lol:

Rather I am just wondering if someone has yet developed a driver for this great DB product.

Many thanks to all who read/respond. :super:

RJ
Open Office 3.1.1
Vista Ultimate
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Base as ODBC source

Post by Villeroy »

Rather I am just wondering if someone has yet developed a driver for this great DB product.
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.
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
User avatar
TheGurkha
Volunteer
Posts: 6482
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.

Re: Base as ODBC source

Post by TheGurkha »

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.
Ubuntu 14.10 Utopic Unicorn, LibreOffice Version: 4.3.3.2
Gurkha Welfare Trust
coolblueice
Posts: 2
Joined: Tue Oct 13, 2009 11:20 pm

Re: Base as ODBC source

Post by coolblueice »

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! :super:

RJ
Open Office 3.1.1
Vista Ultimate
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Base as ODBC source

Post by r4zoli »

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.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Post Reply