Re: [sqlite] Reg: Link error while using sqlite 3

[Black, Michael (IS)]

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

[sqlite] Reg: Link error while using sqlite 3

[Ota Durai]

--- On Tue, 3/22/11, Ota Durai  wrote:


From: Ota Durai 
Subject: Reg: Link error while using sqlite 3
To: sqlite-users@sqlite.org
Date: Tuesday, March 22, 2011, 10:25 AM






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

[sqlite] Reg: Link error while using sqlite 3

[Ota Durai]

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