Can't get Sqlite3 driver

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Can't get Sqlite3 driver

Postby pizzipie » Mon Nov 25, 2019 9:09 pm

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
pizzipie
 
Posts: 50
Joined: Sat Sep 13, 2008 2:28 am

Re: Can't get Sqlite3 driver

Postby robleyd » Tue Nov 26, 2019 7:24 am

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
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3095
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: Can't get Sqlite3 driver

Postby pizzipie » Wed Nov 27, 2019 8:34 am

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
pizzipie
 
Posts: 50
Joined: Sat Sep 13, 2008 2:28 am

Re: Can't get Sqlite3 driver

Postby Hagar Delest » Wed Nov 27, 2019 9:04 am

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.
AOO 4.1.7 on Xubuntu 19.10 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28655
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Can't get Sqlite3 driver

Postby pizzipie » Wed Nov 27, 2019 5:38 pm

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
pizzipie
 
Posts: 50
Joined: Sat Sep 13, 2008 2:28 am


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 3 guests