title: Unable to open SQLite DB created in Android (file is encrypted or is not a database)
body: <p>Some of my users are reporting that they cannot correctly open sqlite databases created in Android using sqlite jdbc or other tools like sqlite browser (http://sourceforge.net/projects/sqlitebrowser/).</p>
  
  <p>Here is an example database with the problem:</p>
  
  <p><a href="http://pocket-for-android.1047292.n5.nabble.com/Desktop-Version-Screenshots-Work-In-Progress-tp4383220p4456017.html" rel="nofollow">http://pocket-for-android.1047292.n5.nabble.com/Desktop-Version-Screenshots-Work-In-Progress-tp4383220p4456017.html</a></p>
  
  <p>This sqlite db was created on a HTC Sensation, running Android 2.3.3 and Sense 3.0.</p>
  
  <p>The exact problem is that if you look at the file in a text editor you can see a bunch of tables being created but if you try and run "select * from groups;" you will get an SQLException: file is encrypted or is not a database.</p>
  
  <p>I have tried using "select sqlite_version;" to see if it is a versioning issue - the sqlite browser says 3.6.18.but different tools give me different version numbers... not sure what is going on with that.</p>
  
  <p>I should also point out that my app copies the db directly from the device (/data/data/com.citc.wallet/databases/wallet.db) onto Dropbox.</p>
  
  <p>Any help would be really appreciated.</p>