SQLite - Could not open database file

Question

I am coding a Xamarin Android application, and am getting an error when trying to create a SQLite database.

Here is my code:

string applicationFolderPath = System.IO.Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "CanFindLocation");
string databaseFileName = System.IO.Path.Combine(applicationFolderPath, "CanFindLocation.db");
SQLite.SQLite3.Config(SQLite.SQLite3.ConfigOption.Serialized);
var db = new SQLiteConnection (databaseFileName);

Here is the error that I am getting:

SQLite.SQLiteException: Could not open database file: /data/data/com.xamarin.docs.android.mapsandlocationdemo2/files/CanFindLocation/CanFindLocation.db (CannotOpen)

I have the same code working in another Xamarin application and would like to know if the exception has something to do with the name of the package?

Thanks in advance

click your database visible top right menu Sql lite Browser select it — Genish Parvadia
– Genish Parvadia, Commented Sep 17, 2014 at 6:44

matthewrdev · Accepted Answer · 2014-09-17 06:35:54Z

28

Does the path folder path that you are providing to SQLite exist? If you haven't created the CanFindLocation folder then opening a connection to that path will fail.

Try:

string applicationFolderPath = System.IO.Path.Combine(System.Environment.GetFolderPath(System.Environment.SpecialFolder.Personal), "CanFindLocation");

// Create the folder path.
System.IO.Directory.CreateDirectory(applicationFolderPath);

string databaseFileName = System.IO.Path.Combine(applicationFolderPath, "CanFindLocation.db");
SQLite.SQLite3.Config(SQLite.SQLite3.ConfigOption.Serialized);
var db = new SQLiteConnection (databaseFileName);

answered Sep 17, 2014 at 6:35

matthewrdev

12.2k5 gold badges56 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

user230910 Over a year ago

Thanks, wish I could upvote several times, took hours to find this post!

Gilberto B. Terra Jr. Over a year ago

I am getting the same error, ... But SQLite.SQLite3 doesnt have "Config" method, why? I am using "sqlite-net-pcl (1.4.118)" and "Xamarin.Forms(3.1.0)"

Pierre Over a year ago

I found that whilst debugging sometimes, the Path magically doesn't exist, then I run again and it works. on and off

matthewrdev Over a year ago

Hilariously, I've just re-discovered this via Google and solved my own issue with my own answer without realising initially... Doh!

DevDave · Accepted Answer · 2023-12-04 13:38:39Z

3

Using MAUI, I was able to get past the same error but setting path to

System.Environment.SpecialFolder.ApplicationData

answered Dec 4, 2023 at 13:38

DevDave

6,98812 gold badges69 silver badges100 bronze badges

Comments

TPG · Accepted Answer · 2019-04-10 07:50:16Z

1

My problem is related to added the option of "SQLiteOpenFlags.Create" during the initialization.

SQLiteAsyncConnection database = new SQLiteAsyncConnection(dbPath, SQLiteOpenFlags.Create);

answered Apr 10, 2019 at 7:50

TPG

3,2591 gold badge41 silver badges56 bronze badges

Collectives™ on Stack Overflow

SQLite - Could not open database file

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related