How establish defult connection to DB in Windows Application

Abhilash J A

Hello everyone,

I am using a SQLite database in a WPF windows application. After installing the windows application the database inside this folder like this.

static SQLiteConnection dbConnection = new SQLiteConnection(@"Data Source=C:\Program Files (x86)\hedronix\qScan\test.s3db;");

But when I am trying to access the database from this location of the windows application showing this error.

"attempt to write a readonly database\r\nattempt to write a readonly database”

How can I solve that?
In this situation, how can I set default connection string for accessing SQLite database after install this application on any local computer?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Software Exibitation5y ago
I try to modify with this code not working how can i solve it

string ConnectionString = @"Data Source=C:\Program Files (x86)\Default Company Name\RCPM Setup\SQLite\RCPM.db;Version=3;Mode=ReadWrite;Journal Mode=Off;";

pls any help me to use it
Bikesh Srivastava9y ago
I think you need to add prquistics
Amit Gupta9y ago
Yes Manas is right. program files directory donot have the normal permiaaion to modify your file (your executable must exists in the program files, so that it has all the respective right access. Also just make sure that SQLite db file donot have a readonly property checked in its properties. Or run your application as "RUN AS ADMINISTRATOR"
Manas Mohapatra9y ago
It seems, it is a permission issue.

Make sure that your application that is installed has add/write/create/delete access to the folder where the sqlite database resides.

http://stackoverflow.com/questions/1518729/how-to-change-sqlite-database-mode

http://stackoverflow.com/questions/2333047/attempt-to-write-a-read-only-database-system-data-sqlite

http://stackoverflow.com/questions/20764269/system-data-sqlite-sqliteexception-attempt-to-write-a-read-only-database-on-wind