Can't get Sqlite3 driver

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
pizzipie
Posts: 54
Joined: Sat Sep 13, 2008 2:28 am

Can't get Sqlite3 driver

Post by pizzipie »

Following is the site used, commands issued, and results in my failed attempt to get the ODBC driver for Sqlite3 for use in LibreOffice Base. I don't have a clue as to where to go to fix this. I looked all over for other sites to download the driver but all trails led to this one.

Thanks in advance for any help,

R
SITE: https://thejeshgn.com/2018/08/23/using- ... l-UnixODBC

COMMAND: ./configure && make ( as per instructions in SITE)
rick@rick-Latitude-E6510:~/Desktop/sqlite-driver/sqliteodbc-0.9996$ ./configure && make

RESULT:
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
.
.
.
checking for sqlite3_table_column_metadata in -lsqlite3... no
checking for sqlite3_profile in -lsqlite3... no
checking for sqlite3_strnicmp in -lsqlite3... no
checking for sqlite3_close_v2 in -lsqlite3... no
checking for SQLite4 header and library... no
configure: WARNING: SQLite4 header file and source not found
configure: error: No usable SQLite header/library on this system
rick@rick-Latitude-E6510:~/Desktop/sqlite-driver/sqliteodbc-0.9996$

COMMAND: make install ( as per instructions in SITE)
rick@rick-Latitude-E6510:~/Desktop/sqlite-driver/sqliteodbc-0.9996$ make install

RESULT:
make: *** No rule to make target 'install'. Stop.
rick@rick-Latitude-E6510:~/Desktop/sqlite-driver/sqliteodbc-0.9996$
Libre Office Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.10
User avatar
robleyd
Moderator
Posts: 5036
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Can't get Sqlite3 driver

Post by robleyd »

Did you also install the development files as mentioned in the link?

Your problem is not really within the scope of this forum.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.1.2; SlackBuild for 24.2.1 by Eric Hameleers
pizzipie
Posts: 54
Joined: Sat Sep 13, 2008 2:28 am

Re: Can't get Sqlite3 driver

Post by pizzipie »

Thanks for the reply. Yes, I did this: sudo apt-get install sqlite3 libsqlite3-dev. before the above.
Your problem is not really within the scope of this forum.
Where should it be?
Libre Office Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.10
User avatar
Hagar Delest
Moderator
Posts: 32594
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Can't get Sqlite3 driver

Post by Hagar Delest »

This is more a system issue first.
Once it is fixed, then you'll be able to get it to work with AOO/LO.

Try the Ubuntu forum. Do you still use 14.04? Sounds rather outdated now.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
pizzipie
Posts: 54
Joined: Sat Sep 13, 2008 2:28 am

Re: Can't get Sqlite3 driver

Post by pizzipie »

Thanks,
I'll try Ubuntu Forum.

I now use as below.
Libre Office Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.10
Post Reply