About Store Forum Documentation Contact



Post Reply 
Database and Esenthel(solved)
Author Message
Rabishan Offline
Member

Post: #1
Database and Esenthel(solved)
hi guys

i'm trying to use sqlite database with esenthel and i'm having some problems while connecting between the two.

i've already connected sqlite3 with visual studio 2010 and its working fine with it.

but when i try to add sqlite code in the esenthel project with similar settings it shows errors.

sqlite3.lib(sqlite3.obj) : MSIL .netmodule or module compiled with /GL found; restarting link with /LTCG; add /LTCG to the link command line to improve linker performance
1>LINK : warning LNK4075: ignoring '/INCREMENTAL' due to '/LTCG' specification
1>sqlite3.lib(sqlite3.obj) : error LNK2001: unresolved external symbol __imp___localtime64_s

i can't understand what is going on.

need some help.

thanks for the support
(This post was last modified: 05-13-2011 06:10 AM by Rabishan.)
05-09-2011 09:46 AM
Find all posts by this user Quote this message in a reply
Zervox Offline
Member

Post: #2
RE: Database and Esenthel
project->properties->linker->General
Enable incremental linking: No (/INCREMENTAL:NO)

project->properties->linker->command line
add
/LTCG
(This post was last modified: 05-09-2011 09:54 AM by Zervox.)
05-09-2011 09:54 AM
Find all posts by this user Quote this message in a reply
Rabishan Offline
Member

Post: #3
RE: Database and Esenthel
thanks for the reply

i changed the settings as you mentioned but error still shows up.

1>sqlite3.lib(sqlite3.obj) : error LNK2001: unresolved external symbol __imp___localtime64_s

i think sqlite configuration is just fine because it does not shows any errors in the sqlite syntax
i just can't figure out whats wrong because outside the esenthel project, everything is okay.
(This post was last modified: 05-09-2011 10:58 AM by Rabishan.)
05-09-2011 10:56 AM
Find all posts by this user Quote this message in a reply
Rabishan Offline
Member

Post: #4
RE: Database and Esenthel
hi

i've attached the sqlite3 here. hope it will be helpful to you guys to find out the problem.


Attached File(s)
.rar  SQlite3.rar (Size: 842.92 KB / Downloads: 8)
05-10-2011 07:25 AM
Find all posts by this user Quote this message in a reply
Esenthel Offline
Administrator

Post: #5
RE: Database and Esenthel
I haven't downloaded it but from the error it looks like you need to include some lib for the local time 64 function
05-10-2011 10:58 AM
Find all posts by this user Quote this message in a reply
Rabishan Offline
Member

Post: #6
RE: Database and Esenthel
can u please explain about it a bit.

btw i have included the lib file and header file of sqlite in the include and library directories. i also have added lib file in additional dependencies.and i have also added the exe file in system data path
is there something i missed.

thanks anyways.
(This post was last modified: 05-10-2011 11:12 AM by Rabishan.)
05-10-2011 11:05 AM
Find all posts by this user Quote this message in a reply
Dynad Offline
Member

Post: #7
RE: Database and Esenthel
localtime_s is a CRT function, There is a macro of this function in the sqlite source code so when you comment it out, it will probably look for localtime and should compile normally.

There is always evil somewhere, you just have to look for it properly.
05-10-2011 03:11 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Rabishan Offline
Member

Post: #8
RE: Database and Esenthel
i couldn't find the function in the sqlite source code. by sqlite source you mean sqlite.c file that comes with sqlite don't you.
i also looked in the time.inl file inside the crt folder of vc but couldn't get any idea.
if someone has used sqlite with esenthel before please do help me.
if not can u please try it out.
and btw i don't think its the problem of esenthel or sqlite. may be some settings i forgot to make up. i don't know
thanks.
(This post was last modified: 05-11-2011 09:10 AM by Rabishan.)
05-11-2011 07:13 AM
Find all posts by this user Quote this message in a reply
dylantan Offline
Member

Post: #9
RE: Database and Esenthel
Just seeking help with Rabishan above mentioned issue. we are still stuck with the above error and unable to resolve it yet. Any idea of how we could solve it?
05-12-2011 06:57 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Zervox Offline
Member

Post: #10
RE: Database and Esenthel
The unresolved issue is because of the code generation settings that the sqllite developers have used for the prebuilt binaries.

This one allows standard EE code generation settings using debugdx10 settings

Sqlite rebuilt for EE

also you can rebuild the binaries/.lib files by doing the following steps for release and debug mode,(my link is built using debug)

copy the EE tutorial vcproj to its own folder.
include the .c and .h files for sqllite(it is inside my .rar file as well), no EE tutorial .h, .cpp files are needed.

select debugdx10 debug, releasedx10 or the wanted build you are going to use.
right click the project inside visual studio->properties->general->configuration type->static library

Also for the .c files
right click properties->C/C++/Precompiled headers and set both of them to "Not Using Precompiled Headers"
build, now you can use it/build it in your project yourself wink
05-12-2011 12:27 PM
Find all posts by this user Quote this message in a reply
dylantan Offline
Member

Post: #11
RE: Database and Esenthel
Wow it work! THANK YOU VERY MUCH ZERVOX!!!!
(This post was last modified: 05-13-2011 06:09 AM by dylantan.)
05-13-2011 06:08 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Rabishan Offline
Member

Post: #12
RE: Database and Esenthel
ya thanks a ton
05-13-2011 06:09 AM
Find all posts by this user Quote this message in a reply
Post Reply