Unable to write to database

Question

Hi there I developed an applicaiton that uses SQLlite database but after making setup project and installing it i get exceptions when writing to it

System.Data.SQLite.SQLiteException: Attempt to write a read-only database

what is the problem?

it works fine while developing at visual studio

EDIT I added user Everyone and assigned it all rights to the folder where the database is placed.that folder was created by the installer and it worked now but what should I do to avoid this ..........because where this application will be deployed they are not much computer literate to do this manually

Answer 1

The database should not be in the same folder as the exe file. The location of exe files, i.e. program files, is protected for security reasons, and modifying the permissions is not the way to go.

You should put data that needs to be written to in the users data area, or the data area for all users.

You can locate this folder using SHGetSpecialFolderPath

Answer 2

In the link forum, the common root cause is permission issue.

http://sqlite.phxsoftware.com/forums/p/864/7498.aspx

Update

Why not encrypt the sqlite database

Encrypt SQLite database in C#

Answer 3

Attempt to write a read-only database - System.Data.SQLite