Page 1 of 1

ODBC-driver to access OpenOffice Base documents?

PostPosted: Mon Aug 17, 2015 7:06 am
by digiajay
Has this problem been resolved? When I tried today to add the data source in Windows-->ControlPanel-->AdminTools-->DataSources(ODBC). I still don't find the OpenOffice is not listed under FileDNS. Anyone can help me to add the OpenOffice database source and create a DNS file?

 Edit: Hagar (moderator): topic split and title changed. 

Re: How to connect to ODBC DSN files?

PostPosted: Mon Aug 17, 2015 3:03 pm
by eremmel
Hi digiajay,

This topic is about something different than you are asking for. Your question is "Is there an ODBC-driver to access OpenOffice Base documents via ODBC". The answer is no there isn't. The reason is that Base is an AOO application and not a database. It is a front end to access multiple databases (including the build database HSQLDB, which is a risk in using for serious work). When you use Base to access an external database, you might be able to access that database directly via ODBC with its native ODBC-drivers. See topics about 'Split database' to learn how to change from a Base document with embedded database to a Base document with an separate database.

Success,

Re: How to connect to ODBC DSN files?

PostPosted: Tue Aug 18, 2015 5:39 am
by digiajay
Hi eremmel,

Thanks for clarification. Now I understand. :-) So there is no equivalent application in OO for MS Access. :-(

Re: How to connect to ODBC DSN files?

PostPosted: Tue Aug 18, 2015 9:22 am
by eremmel
I hope that your conclusive question is intended to address another aspect. Base is a front end to 'any' database. You can build forms etc. It is however not so sofisticated, and the macro language is far from easy. To learn something about Base start reading the tutorials and/or go to YouTube and look for LibreOffice or OpenOffice and Base tutorials. This might give you the info you need to make your decision.