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