Unless you're running multiple SQLite apps you don't gain anything by using a DLL. Plus, is your Pocket PC a i386 CPU?
So try downloading the amalgamation and include sqlite3.c and sqlite3.h in your project. http://www.sqlite.org/sqlite-amalgamation-3070500.zip You'll also find the code will be smaller because the DLL has more options than you probably need built into it. And to add a DLL you need to add the sqlite3.lib file to your project and have the DLL in your PATH. Once you can compile the amalgamation and get things working then you try building a DLL yourself if you need to. Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate ________________________________________ From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Ota Durai [durai...@yahoo.com] Sent: Tuesday, March 22, 2011 12:25 PM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Reg: Link error while using sqlite 3 Dear Sir/Madam, I am working on a project in vs2008 with an pocket pc. I have downloaded the sqlite3.dll and sqlite3.h files from the amalgation & dll of sqlite site. i have created the lib file from this def file using the command "lib /machine:i386 /def:sqlite3.def". and i have linked it to the project. Please help me to resolve this issue, as i have to finish this project before this weekend. And, also i have already used sqlite2 with vs2005 and it worked well. Now when i try to use sqlite3 with vs2008, it hang up with error. Can you please suggest me, whether this error would be vs2008 or sqlite3 or any missing parameters in the setting. When i try to call sqlite3_open function, i get link error as below 1>------ Build started: Project: DB_NEW, Configuration: Debug Pocket PC 2003 (ARMV4) ------ 1>Compiling... 1>stdafx.cpp 1>Compiling... 1>DB_NEW.cpp 1>db.cpp 1>Generating Code... 1>Compiling resources... 1>Microsoft (R) Windows (R) Resource Compiler Version 6.0.5724.0 1>Copyright (C) Microsoft Corporation. All rights reserved. 1>Linking... 1>db.obj : error LNK2019: unresolved external symbol sqlite3_open referenced in function "int __cdecl creteDB(void)" (?creteDB@@YAHXZ) 1>Pocket PC 2003 (ARMV4)\Debug/DB_NEW.exe : fatal error LNK1120: 1 unresolved externals 1>Build log was saved at "file://e:\demo projects\WINCE PROJECTS\DB_NEW\DB_NEW\Pocket PC 2003 (ARMV4)\Debug\BuildLog.htm" 1>DB_NEW - 2 error(s), 0 warning(s) ========== Build: 0 succeeded, 1 failed, 0 up-to-date, 0 skipped ========== Thanks in advance. Please help me to resolve this. I am attaching my project with this mail. Regards, Durai _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
