Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


Hi :)
I think posting to both lists is a good idea.  Hopefully someone can sort this and it's definitely 
something that a few of us would be interested in hearing the answer to.  We don't often hear about 
that particular back-end but it sounds about perfect for quite a few scenarios.  
Good luck and regards from
Tom :)  


--- On Mon, 21/5/12, Jonathan Ryshpan <jonrysh@pacbell.net> wrote:


From: Jonathan Ryshpan <jonrysh@pacbell.net>
Subject: Re: [libreoffice-users] Connecting libreoffice calc to existing sqlite database file
To: users@global.libreoffice.org
Date: Monday, 21 May, 2012, 17:34


On Sun, 2012-05-20 at 01:48 +0200, Mirosław Zalewski wrote:
Sorry about pointing to another thread, but you may find this useful.
Poster 
there managed to connect OpenOffice with sqlite file. I believe the
same should 
work for LO.
Link:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=40&t=9905

As far as I can tell, you will need (aside from LO, of course)
unixodbc and 
libsqliteodbc packages. At least that's how they are called in Debian;
I don't 
know about Fedora, but perhaps they have similar names. 
Thanks very much for the pointer.  I attempted to follow the
instructions, installing the SQLite ODBC Driver, but I have installation
problems. (If you configure wrong, an attempt to access a database will
lock up your system so badly that you need to reboot).  

My particular system runs KDE, which requires iodbc for many
applications, so that is what I am using for the database interface.
Iodbc has two kinds of configuration files in two places, namely:
        /etc/odbc.ini
        /etc/odbcinst.ini
        ~/.odbc.ini
        ~/.odbcinst.ini  (maybe not used)
The iodbc web site has info about ~/.odbc.ini, and by implication
about /etc/odbc.ini, which contains (I believe) default info; but it has
nothing about /etc/odbcinst.ini.  Can someone enlighten me about the
relation about these files and what they are used for?

jon


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.