Android Question android.database.sqlite.SQLiteCantOpenDatabaseException: unknown error (code 14): Could not open dat

[CyclopDroid]

I've create a db with SQLlite and insert into my Dirassets,but when i load it, this errore appear.
Where is the problem?

LstDati.Clear
    Dim Cursor1 As Cursor                               
    Dim txt As String
    SQL_Lettura.Initialize(File.DirAssets,"FrsPa.db",False)
    txt = "SELECT * FROM Parolando WHERE lenParola = " & Prima & " or lenParola = " & Seconda & " order by lenParola"
    Cursor1 = SQL_Lettura.ExecQuery(txt)

.....
......
......
.....

Thanks

 

[DonManfred]

You first need to copy the db to a place where it is writeable... DirAssets are write-protected.

 

[CyclopDroid]

But my Db it's no writable... it's only for read

 

[DonManfred]

SQLite writes to this db too. Even if you just want to read.
Try it or search the forum and found the same answer a lot of times.

I´m sure this info is part of the beginner guide in section SQLite also

 

[CyclopDroid]

Ok. I provvide to change the destination into DirInternal and test if work.
Thanks you. see ya.

 

[Jmu5667]

Hi have you check the DB has been created, and also if the storage is mounted.

 

[CyclopDroid]

Yes are sure. The DB it's mounted and full. With SQLlite I see all data and the SQL command result true value.

 

[CyclopDroid]

Ok the problem is really the DirAssets point.... I controll if file exist into Dirinternal and, if not exist, I copy my db from DirAssets to DirInternal and, when I finish, delete it.