Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

SQLite with Eclipse Plug-in project

Created by: jancumps at: 3/25/2017 10:25 AM (1 Replies)

Rating (0)

Thanks 0

2 Entries

3/25/2017 10:25 AM	Rate (0)
jancumps Advanced Member Joined: 2/14/2017 Last visit: 4/17/2023 Posts: 59 Rating: (9)	I'm trying to create an SQLite project. I'd need to include the library in the linker but do not know how to link it in the Eclipse properties. Lib location: D:\SIEMENS\SDK\iot2000-sdk-windows-2.1.2\sysroots\i586-nlp-32-poky-linux\usr\lib Lib: libsqlite3.so Including the header works fine. Eclipse finds it in "iot2000-sdk-windows-2.1.2\sysroots\i586-nlp-32-poky-linux\usr\include" No compile errors. Linker error: i586-poky-linux-g++ -lmraa -fno-use-linker-plugin "--sysroot=D:\\SIEMENS\\SDK\\iot2000-sdk-windows-2.1.2/sysroots/i586-nlp-32-poky-linux" -o iot2020_sqlite main.o main.o: In function `main': D:\users\jancu\workspace_eclipse\iot2020_sqlite\IOT2000 Release/..\main.cpp:14: undefined reference to `sqlite3_open' D:\users\jancu\workspace_eclipse\iot2020_sqlite\IOT2000 Release/..\main.cpp:17: undefined reference to `sqlite3_errmsg' D:\users\jancu\workspace_eclipse\iot2020_sqlite\IOT2000 Release/..\main.cpp:23: undefined reference to `sqlite3_close' collect2.exe: error: ld returned 1 exit status Source (I've also attached the Eclipse project, but you'll need to change the POKY_HOME environmental variable to point to your SDK install) #include <iostream> using namespace std; #include <sqlite3.h> int main(void) { cout << "Hello IOT2000." << endl; sqlite3 *db; int rc; rc = sqlite3_open("test.db", &db); if( rc ){ sqlite3_errmsg(db); // fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db)); return 0; }else{ // fprintf(stderr, "Opened database successfully\n"); } sqlite3_close(db); return 0; } Attachment iot2020_sqlite.zip (396 Downloads)
	Last edited by: jancumps at: 3/25/2017 10:29:43 AM edit: focus on getting lib added in eclipse
Suggestion To thank Quote Answer

3/25/2017 10:33 AM	Rate (0)
jancumps Advanced Member Joined: 2/14/2017 Last visit: 4/17/2023 Posts: 59 Rating: (9)	Answered my own question. Logging an issue sometimes helps to find the answer. Add -lsqlite3 after the -lmraa option in Properties -> C/C++ Build /Settings -> IOT2000 Linker -> General

Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Related topics by keywords:

SIMATIC IOT2000 Software

Follow us on