On Tue, 18 Nov 2008 11:34:15 -0200, "perperino pomulo" <[EMAIL PROTECTED]> wrote in General Discussion of SQLite Database <sqlite-users@sqlite.org>:
>Hello. >First I want to apologise because my english is very poor. > >I have an aplication that contains an SQLite 2.1 database. This application >was made in visual basic 6 and i use the ags_sqlite dll to manage the >database. Now i need to encrypt the data base. >The problem is that i have different tables with diferent data types so it >is complicated to encrypt data before insert it into database. Beside of >this i have a textbox in which the user can perform sqlite querys so what i >need is to encript the database itself. On-the-fly encryption is a payed-for version of sqlite. http://www.hwaci.com/sw/sqlite/prosupport.html Perhaps you will have to add or change a C-call in your vb6 wrapper. >Looking on the internet i see that more recentlys version of sqlite support >onthefly encryption, then my question is if there are any way to implement >it on visual basic 6. >I'm testing this: http://tannertech.net/sqlite3vb/ Indeed I doubt that will work with SQLite 2.1. Conversion is easy: sqlite2 your.db.v2 .dump | sqlite3 your.db.v3 , although it might be better do do it in another way, for example in order to specify non-default 'sticky' PRAGMAs. >the syntax is very similar to the ags's and works fine, but the problem is i >don't know how to create an encrypted database and then how to open it. > >If somebody can bring me any idea i papreciate it. thanks. HTH -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
