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: 5106
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.
Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.3.2; SlackBuild for 24.2.3 by Eric Hameleers
---------------------
Roses are Red, Violets are Blue
Unexpected '{' on line 32
.
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: 32697
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 24.2 on Xubuntu 24.04 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