Sorry for my mistake. I was creating database using sqlite3 API and trying to open it with sqlite command line client version 2.7
Thanks a lot. Lloyd. On Wed, 2006-10-25 at 11:51 +0530, Lloyd wrote: > Thanks for your informative reply. > > I would like to know, whether I can open a database which is created > using the sqlite API from a program, using the sqlite command line > client? > > [I tried it using sqlite <db name with full path> and it shown the > following error- > > Unable to open database "/root/userdb": file is encrypted or is not a > database . > > How can I open the database using sqlite command line? ] > > Thank you very much. > > Lloyd. > > > > > On Tue, 2006-10-24 at 11:02 +0000, [EMAIL PROTECTED] wrote: > > Lloyd <[EMAIL PROTECTED]> wrote: > > > Hi List, > > > Whether the data base which we create through the program will be in > > > encrypted form? > > > > The public-domain version of SQLite does not encrypt the data. > > But commerical extensions that encrypt the data are available. > > See, for example, http://www.hwaci.com/sw/sqlite/prosupport.html#crypto > > > > > > > > If yes, how can I see the result in sqlite? (How can use select > > > statements on this database?) > > > > > > My application creates a database and to analyze the results in the > > > database, it will be easy for me to use the interface provided by the > > > sqlite. How can I open the database in SQLite ? > > > > > > > When a database is encrypted you must supply the encryption key > > before reading or modifying the database. You can do this in > > several ways. There is a pragma: > > > > PRAGMA key=? > > > > If the database is being loaded using an ATTACH statement then > > you specify the key in the USING clause of the ATTACH: > > > > ATTACH DATABASE 'encrypted.db' AS e2 USING :key > > > > Or you can use the C/C++ API: > > > > sqlite3_key(db, zKey); > > > > Once the key is established, the database content is automatically > > decrypted as it is read from the disk and reencrypted as it is > > written back to the disk. > > > > If you use the command-line client, there is a special option > > to specify the key: > > > > sqlite3 -key 'hello' database.db > > ^^^^^^^^^^^^ > > > > After that the command-line client works just like it normally > > does. > > > > None of the above works in the public domain version of SQLite. > > You have to purchase a license for a version of SQLite that > > supports encryption in order to use these features. > > > > -- > > D. Richard Hipp <[EMAIL PROTECTED]> > > > > > > ----------------------------------------------------------------------------- > > To unsubscribe, send email to [EMAIL PROTECTED] > > ----------------------------------------------------------------------------- > > ______________________________________ Scanned and protected by Email scanner ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
