C# .net -> SQLite error: Unable to open the database file

Question

I'm getting "System.Data.SQLite.SQLiteException: Unable to open the database file." when I attempt to access the database to save a record upon the "first" opening of my program.

Here's the thing, it works fine when debugging locally in Visual Studio, but stops working when I package the program in an installer, and then install the program somewhere.

I was guessing that it was the location of the database, which I just have set at database.s3db without a path, because it is stored next to the program's exe, but how could that cause problems?

I'm at a loss, any further ideas or suggestions for solving this problem would be greatly appreciated.

Darin Dimitrov · Accepted Answer · 2011-01-02 09:44:36Z

7

Maybe you are installing the program in a folder which the user doesn't have write permissions so cannot modify the database file.

answered Jan 2, 2011 at 9:44

Darin Dimitrov

1.0m276 gold badges3.3k silver badges3k bronze badges

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

5 Comments

CODe Over a year ago

That was exactly it. Why is it that ProgramFiles has places that can't be modified? Don't most programs modify their own files?

Darin Dimitrov Over a year ago

@CODe, no, starting from Windows Vista only the administrator have write permissions to the program files folder. You have to use the corresponding c:\users\AccountName folder to store user specific files.

k3b Over a year ago

´Why is it that ProgramFiles has places that can't be modified?´ In order to make it more difficuilt for malware (virus, trojan) to install itself

chris Over a year ago

@CODe: I strongly disagree - this is actually one of the few things MS got right in Vista and subsequent versions. UNIX-like systems have been allowing regular users write access only to their home directories by default since forever, and that is a Good Thing. It prevents malicious software from doing Bad Stuff and dumb users from doing Dumb Stuff.

Joel Coehoorn Over a year ago

If the database is to be shared among all users of a system, you can put it in the All Users Application Data folder.

Terrance00 · Accepted Answer · 2018-07-23 13:24:51Z

-1

Please update your DataSource Format like this :

@"C:\Users\Mehmeto\Documents\Visual Studio 2015\Projects\......\bin\myDB.sqlite";

Where the directory points to where your project is located.

edited Jul 23, 2018 at 13:24

Terrance00

1,6981 gold badge21 silver badges30 bronze badges

answered Jul 23, 2018 at 13:03

Mehmet Ali Önde

1

Collectives™ on Stack Overflow

C# .net -> SQLite error: Unable to open the database file

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related