Hi, friends.
I've downloaded wxSqlite3 and compiled with VC++ 2008 EE successfully (DLL Unicode Release Mulitlib DLL Win 32).
However I need encryption features on it. I read the 'readme' file, but I'm confused with the instructions.
¿How can I compile wxSqlite3 with encryption capabilities, from VC++ 2008 EE, without compiling sqlite again?
Newbie wxSqlite3 question Topic is solved
Re: Newbie wxSqlite3 question
If you want to use the precompiled SQLite DLL with encryption coming with wxSQLite3 you need to either copy the files in sqlite3/secure to sqlite3/lib or have to direct the compiler/linker to the right library path by changing the additional libaries path in the project settings.hsalas wrote:However I need encryption features on it. I read the 'readme' file, but I'm confused with the instructions.
¿How can I compile wxSqlite3 with encryption capabilities, from VC++ 2008 EE, without compiling sqlite again?
Additionally you have to enable access to the encryption feature by setting the preprocessor symbol
WXSQLITE3_HAVE_CODEC=1
You can do this in the project settings or you can change header file wxsqlite3opt.h to your needs.
Regards,
Ulrich
If wxUSE_DYNAMIC_SQLITE3_LOAD is set to 1 the SQLite link library sqlite3.lib is not needed. Usually it should not be a problem to leave wxUSE_DYNAMIC_SQLITE3_LOAD set to 0 if the path for additional link libraries is correctly set.hsalas wrote:On the other hand, I had to set wxUSE_DYNAMIC_SQLITE3_LOAD to 1 for a success complilation. The "readme" file does not mention, at least not what I saw.
The encryption extension coming with wxSQLite3 is built into the SQLite library itself and is independent of the wxSQLite3 wrapper and wxWidgets. If encryption is activated by specifying a password phrase (i.e. either from wxSQLite3 in the Open method of wxSQLite3Database or via a PRAGMA KEY command in the command line tool) encryption takes place transparently. When SQLite loads a database page into memory it is decrypted and when it saves a page to file it is encrypted.hsalas wrote:One more question: ¿wxSqulite3 encrypting database process is on the fly?
Regards,
Ulrich