Re: [libreoffice-users] Connecting libreoffice calc to existing sqlite database file

On Mon, 2012-05-21 at 09:34 -0700, Jonathan Ryshpan wrote:
> 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.

I have been able to establish a connection between libreOffice base and
my database, using sqliteodbc and unixODBC (which are the names on
Fedora).  I have not been able to use libiodbc, which serves the same
function as unixODBC and is the default driver on KDE, probably because
of documentation problems; libiodbc runs fine on all the KDE
applications that require it, but not for libreOffece and me.

But the database doesn't look like what I had expected it to: sqlite
databases contain within themselves the names and data types of all the
entries, but when libreOffice opens the database, there is no such data
visible.  Am I missing something.  A dump of the database using 
"$ sqlite3 <archive>.sdb .dump" looks fine.  Is this what I should expect,
or is something wrong, or am I missing something?

Thanks - 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