Fatal error sqlite3 h no such file or directory

make fails with fatal error: sqlite3.h: No such file or directory compilation terminated. #86

I cloned the mongrel2 and ran make command and finally ended in following error.

/codes/python/mongrel2$ make
cc -g -O2 -Wall -Wextra -Isrc -pthread -rdynamic -DNDEBUG -D_FILE_OFFSET_BITS=64 -fPIC -c -o src/config/config.o src/config/config.c
src/config/config.c:42:21: fatal error: sqlite3.h: No such file or directory
compilation terminated.
make: *** [src/config/config.o] Error 1

I looked into the src/config/config.c at line no 42 there is a header inclusion as follows #include , I grepped for sqlite3.h but I couldn’t find it.

Note: I have installed sqlite3 already in my system so I commented and tried installation found in many places sqlite3 is required.

The text was updated successfully, but these errors were encountered:

Is this on Linux? Maybe you are using a distribution that splits the «runtime» package from de «dev» package. If so you could search for something like «sqlite3-dev» package for your linux distribution.

Can you list all files belonging to a installed package on your distro? This way you will se if your installed sqlite3 package really includes the headers.

You need to install the development libraries for sqlite. Assuming a
debian or ubuntu setup you need to install the package libsqlite3-dev

edit: Urgh email reply missed your reply.

@daltonmatos @jsimmons : Thanks you both are right, I didn’t have sqlite3-dev package. It was under ubuntu, I fixed it by sudo apt-get install libsqlite3-dev , I think we should add this in documentation.

Источник

Anaconda error: Cannot open include file: ‘sqlite3.h’: No such file or directory

pip install peewee fails with Anaconda on Windows 10.

• OS: Windows 10
• Python: Python 3.6.4 :: Anaconda, Inc.
• Cython: 0.27.3

error

playhouse_sqlite_ext.c(531): fatal error C1083: Cannot open include file: ‘sqlite3.h’: No such file or directory error: command ‘D:\MyIDE\VS2015\VC\BIN\x86_amd64\cl.exe’ failed with exit status 2

But when I used official Python without Anaconda, it installed successfully.So what can I do for installing peewee successfully with Python in Anaconda?

2 Answers 2

I had same problem on Win7-X86 with VisualStudio 2017 Community and Anaconda 3 installed. Problem is that sqlite3.h not found during compiling with C/C++ compiler. File is available in Anaconda installation in LibraryInclude. During linking you will not find sqlite3.lib in Libraryinclude. You can add proper CL and LINK environment variables to solve problems.

Below presented pyx.bat to start python.exe with additional environment variables to fix problem. Don’t forget fix PYTHONPATH for your location either inside BAT or you need it in system level environment. Use it from command line as of:

pyx -m pip install -U peewee

I have this pyx.bat on the PATH, while no Python on the path

As of 3.1.x, you should be able to specify an environment variable to skip compilation of sqlite-extensions. See docs: http://docs.peewee-orm.com/en/latest/peewee/installation.html#skip-compilation-of-sqlite-extensions

Hot Network Questions

To subscribe to this RSS feed, copy and paste this URL into your RSS reader.

Site design / logo © 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA . rev 2023.1.16.43160

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.

Источник

(Windows) fatal error: sqlite3.h: No such file or directory

I am trying to build a c++ application that uses sql.

For that I need sqlite3 header. I have already installed sql in my system and

sqlite3 in terminal gives:

SQLite version 3.36.0 2021-06-18 18:36:39 Enter «.help» for usage hints. Connected to a transient in-memory database. Use «.open FILENAME» to reopen on a persistent database. sqlite>

I have tried searching for this over web and found many relevant solutions including this.

Since I am working on Windows,

did not work. I also tried to change

with sqlite.h file in the same directory as my cpp code file(as I found people using it in videos). But this time I ended up with »’ C:UsersusernameAppDataLocalTempccwQfHZB.o:temp.cpp:(.text+0x1e): undefined reference to `sqlite3_open’ collect2.exe: error: ld returned 1 exit status »’

I am quite new to it, so any help is appreciated. Thanks.

2 Answers 2

So you clearly need a tutorial in how to use third party libraries. That’s too much to describe here. But this might get you started.

You have to tell your compiler where the header files you are including are located. Having them installed is not enough. Use the -I compiler option for that.

You have to tell your compiler where the library files that you are linking with are located. Having them installed is not enough. Use the -L compiler option for that.

You have to tell your compiler the names of the libraries that you are linking with. Having them installed is not enough. Use the -l compiler option for that.

All these options may need to be given multiple times depending on your precise setup and the libraries you are using.

Sorry but I don’t know what the sqlite libraries are called, and obviously I don’t know where you installed stuff.

Moving header files around is never the right solution, and any video you saw that does that doesn’t know what they are talking about. Install stuff where you think is best and then tell your compiler where that is. Any sqlite tutorial that uses the g++ compiler should go through this process in more detail, but there are a lot of bad C++ tutorials out there.

Источник

fatal error: sqlite3.h: No such file or directory

I’m trying to build a C application through cross compiling for a Zynq board (ARM architecture). When I type make without mentioning the ARM arch, it works fine on my laptop. But as soon as I modify the Makefile, I get an error saying:

The Makefile looks like this:

What am I doing wrong? Thanks for any help I can get.

2 Answers 2

I got this issue fixed with

You don’t provide enough information to say for sure: in particular, you don’t say where the sqlite3.h file actually is on your filesystem. However, based on what you do show I suspect you need to change the INCLUDES variable, to this:

(or else change the #include in your code to be #include «sqlite/sqlite3.h» ). This is assuming that the header file is in the same directory as the sqlite3.c source file.

Note that this is a bad/confusing implementation. You should be putting the -I flag in the INCLUDES variable:

INCLUDES is plural which may lead someone to believe they could add multiple directories in that variable, but if you leave it the way you have it, this will cause strange compiler errors:

will add the flags -Ilib/sqlite another/dir . note how the second directory doesn’t have a -I option.

Of course, by convention you should be using CPPFLAGS (for C preprocessor flags), not INCLUDES , but. 🙂

Источник

Errors setting up CMake and vcpkg on windows `Can’t open include file`

I’ve been trying to follow the vcpkg setup guide but I’ve been unable to solve the build error I get on the final step:

My vcpkg setup process is as follows:

• > git clone https://github.com/Microsoft/vcpkg.git
• > cd vcpkg
• > .bootstrap-vcpkg.bat
• > vcpkg install sqlite3:x64-windows
• > vcpkg integrate install

I confirm the sqlite install:

I create the following files in a test repo:

Start Build:

I then generate the build files by running the following in the build folder, and note that it is able to find SQLite3 :

Lastly, I trigger the build, which fails:

1 Answer 1

While you provide the SQLite3 library for linking with target_link_libraries() , you need to let your executable know where to find the header files. Use target_include_directories() :

CMake will populate these variables if SQLite3 is found (which it looks like it is):

• SQLite3_INCLUDE_DIRS : where to find sqlite3.h, etc.
• SQLite3_LIBRARIES : the libraries to link against to use SQLite3.
• SQLite3_VERSION : version of the SQLite3 library found
• SQLite3_FOUND : TRUE if found

So if your call to target_link_libraries() doesn’t work as expected, try using $ instead of sqlite3 .

Источник

12:58:22: Starting: "C:Qt5.15.0mingw81_64binqmake.exe" C:UsersLucasDevelopment_qetqelectrotech-source-mirrorqelectrotech.pro -spec win32-g++ "CONFIG+=debug" "CONFIG+=qml_debug"
Project ERROR: sqlite3 development package not found
12:58:22: The process "C:Qt5.15.0mingw81_64binqmake.exe" exited with code 3.
Error while building/deploying project qelectrotech (kit: Desktop Qt 5.15.0 MinGW 64-bit)
When executing step "qmake"

#comment the line below to disable the project database export
DEFINES += QET_EXPORT_PROJECT_DB

unix|win32: PKGCONFIG += sqlite3

projectdatabase.cpp:33: error: sqlite3.h: No such file or directory
..qelectrotech-source-mirrorsourcesdataBaseprojectdatabase.cpp:33:10: fatal error: sqlite3.h: No such file or directory
 #include <sqlite3.h>

unix: PKGCONFIG += sqlite3 
win32: CONFIG += sql

win32:LIBS += "C:/<path>/sqlite3.dll"
win32:INCLUDEPATH += "C:/<path>"    #path to sqlite3.h header file

Generated in 1.984 seconds (21% PHP — 79% DB) with 9 queries