Android Question SQLiteCantOpenDatabaseException

[wimpie3]

I'm currently testing an app on several devices.

One of them, an older HTC, crashes with the following error:
android.database.sqlite.SQLiteCantOpenDatabaseException: unable to open database file

This happens in a module on this line:

SQL.Initialize(File.DirDefaultExternal, "mydb.db", True)

Since the "true" flag is passed, a new db should be created, but for one reason or another this does not seem to work on this specific device.

What am I missing?

 

[DonManfred]

What am I missing?

my guessing: permission to write on external storage?

 

[wimpie3]

Uhmmm... so why would it work on other machines and not on my HTC?

Plus, this is what Erel wrote before:

File.DirRootExternal and File.DirDefaultExternal have a special side effect of adding the STORAGE permission to your manifest file.

 

[DonManfred]

Except if you are using a removepermission

 

[wimpie3]

Well, I'm not

 

[Pendrush]

If File.ExternalWritable = True Then
    SQL.Initialize(File.DirDefaultExternal, "mydb.db", True)
Else     
    SQL.Initialize(File.DirInternal, "mydb.db", True)
End If

 

[Pendrush]

Or you can use this code:

SQL.Initialize(DataBasePath, "mydb.db", True)

Sub DataBasePath As String
   If File.ExternalWritable = True Then
     Return File.DirDefaultExternal  
   Else
     Return File.DirInternal
   End If
End Sub

 

[wimpie3]

This seems to have done the trick... can't I use DirInternal on all occasions and simply leave out the if/then/else?

 

[Pendrush]

Check my post above your. Or always use DirInternal.

 

[wimpie3]

THANKS A MILLION!