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

Question

I'm having a little bit of a problem that I thought was related to Security but, turns out can't be as I did almost everything ...

Plenty of information on this on the web but nothing has an answer to fix the issue.

Let me tell my steps:

Have a Website on VS2k8 that when I debug or start from Cassini, all works fine
When setting up IIS 7.5 (Win7) to point to this website and after adding IIS_IUSRS Modify rights I get the error
Same thing using IIS 6.0!

Img: Security on Database File from IIS 7.5

_{(source: balexandre.com)}

Note that all other files and folders have the same rights as above

The full Error is:

Log: Executing query on SQLite Database

Message ***************************************
Attempt to write a read-only database
attempt to write a readonly database

Stack Trace ***********************************
at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
at System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at soDatabaseManager.CommitPersonsToKitchenDatabase() in c:\Adwiza\Kitchen\App_Code\soDatabaseManager.cs:line 242

P.S. Keep in mind that this has to work with IIS 6 (windows 2003) as well, the IIS 7.5 is only for troubleshooting as we have more control in everything...

Yes I did, it is not read-only, non of the files in IIS are :-/ — balexandre
– balexandre, Commented Feb 25, 2010 at 10:03

Darin Dimitrov · Accepted Answer · 2010-02-25 10:12:23Z

16

Make sure that the anonymous web user account (NETWORK SERVICE or maybe something else) under which your web application executes has read/write/create/delete access to the folder where the sqlite database resides.

answered Feb 25, 2010 at 10:12

Darin Dimitrov

1.0m276 gold badges3.3k silver badges3k bronze badges

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

1 Comment

balexandre Over a year ago

under IIS 7.5 you can choose wither to use a USER or Application, my anonymous User is IUSR (as you can see, it exists in the Security Panel) and I have the same error on using Application Pool identity (img: balexandre.com/temp/2010-02-25_1150.png )

Alejandro Montilla · Accepted Answer · 2017-03-03 15:00:52Z

3

The other answer give me an idea about the problem, but my solution was a bit differente. The problem was that the user did not have permissions to modify the folder and the .db file. So I give permission to the user Everyone (collective group for Authenticated Users and Guest). The permisions on NETWORK SERVICE (or similars) did not solve in my case.

Note: The IIS must be restarted, after the change, to load the change made.

answered Mar 3, 2017 at 15:00

Alejandro Montilla

2,6543 gold badges34 silver badges37 bronze badges

1 Comment

Mike Brind Over a year ago

For me, it was the application pool identity, but +1 for advice to restart - but that only applied to the application pool itself, in my case. Not all of IIS.

Alper Sahin · Accepted Answer · 2020-03-14 10:34:09Z

-1

ss----enter image description here

You should also do this. error for--->Unable to open the database file You must add a connection string.--"Version=3;Mode=ReadWrite;New=False;Compress=True;Journal Mode=Off;";

answered Mar 14, 2020 at 10:34

Alper Sahin

1511 silver badge2 bronze badges

1 Comment

Gert van den Berg Over a year ago

Images of text is a bad idea (they can't be searched, external sites take them down sometimes), rather copy and paste the text.

Collectives™ on Stack Overflow

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

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related