ODBC-driver to access OpenOffice Base documents?

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

ODBC-driver to access OpenOffice Base documents?

Postby digiajay » Mon Aug 17, 2015 7:06 am

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. 
--
Thanks
Ajay.
Using OpenOffice version 4.1.1 on Windows 7 Professional Operating System
digiajay
 
Posts: 2
Joined: Mon Aug 17, 2015 7:02 am

Re: How to connect to ODBC DSN files?

Postby eremmel » Mon Aug 17, 2015 3:03 pm

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,
Is your question answered: edit your initial post add "[Solved]" to the subject and check V
LO4.2.8 for work with ORB; AOO4.1.4,LO5.2.5/6.0.5 on W7E SP1 64bit
It's Microsoft marketing that tells you computers are qualified for non-technicians
User avatar
eremmel
Volunteer
 
Posts: 1028
Joined: Tue Dec 30, 2008 1:15 am
Location: Barneveld, Netherlands

Re: How to connect to ODBC DSN files?

Postby digiajay » Tue Aug 18, 2015 5:39 am

Hi eremmel,

Thanks for clarification. Now I understand. :-) So there is no equivalent application in OO for MS Access. :-(
--
Thanks
Ajay.
Using OpenOffice version 4.1.1 on Windows 7 Professional Operating System
digiajay
 
Posts: 2
Joined: Mon Aug 17, 2015 7:02 am

Re: How to connect to ODBC DSN files?

Postby eremmel » Tue Aug 18, 2015 9:22 am

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.
Is your question answered: edit your initial post add "[Solved]" to the subject and check V
LO4.2.8 for work with ORB; AOO4.1.4,LO5.2.5/6.0.5 on W7E SP1 64bit
It's Microsoft marketing that tells you computers are qualified for non-technicians
User avatar
eremmel
Volunteer
 
Posts: 1028
Joined: Tue Dec 30, 2008 1:15 am
Location: Barneveld, Netherlands


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 1 guest