SQLite Error 14: 'unable to open database file' if in root folder

Question

My DatabaseContext has:

string physicalPath = "Filename=" + Path.Combine(Path.Combine(Directory.GetCurrentDirectory(), "Data"), "Database.db");
optionsBuilder.UseSqlite(physicalPath);

My Startup has:

using (var client = new DatabaseContext())
{
   client.Database.EnsureCreated();
}

It works perfectly with "D:\\Database.db" but that's not very portable so I need to use its own directories.

Has anyone any idea?

Update: I tried again with a tutorial here and got same error in an exception page.

"An unhandled exception occurred while processing the request. SqliteException: SQLite Error 14: 'unable to open database file'. Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(int rc, sqlite3 db)"

Update: I get "System.UnauthorizedAccessException: 'Access to the path 'C:\Program Files\IIS Express\test.txt' is denied.'" when I try

string path = Path.Combine(Directory.GetCurrentDirectory(), "test.txt");

using (FileStream fs = File.Create(path)) { Byte[] info = new UTF8Encoding(true).GetBytes("This is some text in the file."); // Add some information to the file. fs.Write(info, 0, info.Length); }

AdrianK09 · Accepted Answer · 2019-07-21 10:08:14Z

1

How about using the following to construct the path that points to your DB file?:

// Gets the current path (executing assembly)
string currentPath = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location);
// Your DB filename    
string dbFileName = "stuff.db"; 
// Creates a full path that contains your DB file
string absolutePath = Path.Combine(currentPath, dbFileName);

Do note that you will need to include the following using statements in your DatabaseContext:

using System.IO;
using System.Reflection;

answered Jul 21, 2019 at 10:08

AdrianK09

497 bronze badges

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

1 Comment

Matthew Lock Over a year ago

note that this ends looking inside the bin folder for the database

Ali · Accepted Answer · 2020-03-09 06:10:25Z

0

You need to put your Database under App_Data folder. All the SQLite required dll need to be in bin folder. Also the SQLite.Interop.dll need to be in x64 and x86 folder under bin.

edited Mar 9, 2020 at 6:10

Ali

2,7643 gold badges37 silver badges62 bronze badges

answered Mar 9, 2020 at 4:37

Chun Tung

1

Collectives™ on Stack Overflow

SQLite Error 14: 'unable to open database file' if in root folder

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related