LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 01-17-2015, 11:28 AM   #1
rshepard
Member
 
Registered: Oct 2007
Location: Troutdale, Oregon
Distribution: Slackware
Posts: 435

Rep: Reputation: 28
Building/Installing sqlite-odbc: libsqliteodbc not found


Context: I am building a single-user database application to be used by those running Windows. To make life easier for me and them, I want to use LibreOffice's Base application with SQLite as the rdbms back end.

LO's Base does not natively support SQLite; its native single-user database engine is hypersql (HSQLDB) written in java. I use sqlite and postgres and don't need to learn another dbms SQL syntax. So, I got the source for sqliteodbc-0.9991, configured, built, and installed it. Added the README file's suggested content to /etc/odbc.ini and ~/.odbc-ini. When I tried to connect LO's Base to the sqlite .db file it failed because it could not find libsqliteodbc.so. Sure enough, that's not on the system.

I've not before worked with ODBC or iODBC and have no preference for one over the other. What I need is assistance getting one or the other installed and working here.

All suggestions and advice appreciated.

Rich
 
Old 01-17-2015, 01:50 PM   #2
weibullguy
ReliaFree Maintainer
 
Registered: Aug 2004
Location: Kalamazoo, Michigan
Distribution: Slackware 14.2
Posts: 2,815
Blog Entries: 1

Rep: Reputation: 261Reputation: 261Reputation: 261
If you built against V3 of SQLite, the library will be libsqlite3odbc.
 
1 members found this post helpful.
Old 01-18-2015, 08:38 AM   #3
rshepard
Member
 
Registered: Oct 2007
Location: Troutdale, Oregon
Distribution: Slackware
Posts: 435

Original Poster
Rep: Reputation: 28
Quote:
Originally Posted by weibullguy View Post
If you built against V3 of SQLite, the library will be libsqlite3odbc.
Aha! I should have known this. Now the trick is getting LO's Base to look for the correct library. I'll ask how to proceed on that mail list.

Very much appreciated,

Rich
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Building SQLite-3.8.8 on Slackware-14.1 rshepard Slackware 6 01-20-2015 06:12 PM
LXer: Sqlite-Commander - A ncurses based tool to display the records and tables of a sqlite database LXer Syndicated Linux News 0 01-02-2011 08:11 AM
SQlite odbc drivers errro Ashok_mittal Linux - Newbie 1 01-13-2009 04:23 AM
installing sqlite under cyqwin Dave31836 Programming 1 02-24-2005 06:55 PM
Connect to SQLite with Tora & ODBC kkempter Linux - Software 2 07-22-2004 03:00 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:06 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration