Sqlite .NET and Entity Framework - "attempt to write a readonly database"

Question

---edit--- Is there any additional information I can give to help solve this problem?

I'm trying to get up and running with a Sqlite and Entity Framework within a .NET WCF web service.

When I try to save anything to the database, I'm getting the error "attempt to write a readonly database". Here's the full error information:

System.Data.EntityException: An error occurred while starting a transaction on the provider connection. See the inner exception for details.

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

Attempt to write a readonly database
at System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
at [snip]........................................................> at System.Data.EntityClient.EntityConnection.BeginDbTransaction(IsolationLevel isolationLevel) at System.Data.Common.DbConnection.BeginTransaction() at System.Data.EntityClient.EntityConnection.BeginTransaction() at System.Data.Objects.ObjectContext.SaveChanges(Boolean acceptChangesDuringSave) at System.Data.Objects.ObjectContext.SaveChanges() at ...

Here's my EF configuration inside Web.config (with line breaks for easier reading):

<connectionStrings>
   <add 
      name="FooEntities" 
      connectionString="metadata=res://*/FooDataModel.csdl|
      res://*/FooDataModel.ssdl|
      res://*/FooDataModel.msl;
      provider=System.Data.SQLite;
      provider connection string='data source=C:\domains\myfoosite.com\wwwroot\FooService\Foo.sqlite'"
      providerName="System.Data.EntityClient" />
<connectionStrings>

Why am I receiving this error? Why is the database read-only?

Some things I've tried:

Ensured the directory and file is write-able by the web service. (I've tried writing plain text files to the same directory as a test.)
I've added the 'read only=False' to the connection string.

Does the user you're using to connect have write access to the database? Can you connect and write to the database using Management Studio (or equivalent)? — ChrisF
– ChrisF, Commented Jun 28, 2010 at 13:48
Hmmm. I'm not specifying credentials of any kind -- didn't specify Windows auth or Forms auth. I can connect and write to the database on my local machine, of course. I will try connecting on the web server. — Judah Gabriel Himango
– Judah Gabriel Himango, Commented Jun 28, 2010 at 13:57
From my understanding, Sqlite doesn't have Windows auth or Forms auth. It's just a single-file database, no services, no authentication. Am I mistaken? — Judah Gabriel Himango
– Judah Gabriel Himango, Commented Jun 28, 2010 at 18:40

Judah Gabriel Himango · Accepted Answer · 2010-07-04 02:39:58Z

4

Turns out the problem was IIS security settings. I had to turn on script write access, and magically it started working.

answered Jul 4, 2010 at 2:39

Judah Gabriel Himango

60.2k39 gold badges162 silver badges218 bronze badges

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

3 Comments

Louis Somers Over a year ago

I've run into the same problem. Where did you turn "script write access" on? I looked in the handlers, but there I can choose between "write" and "script", but not both (radio buttons).

Louis Somers Over a year ago

I figured it out. It's the Windows level write permission on the file system for the IIS user (IIS_IUSRS) which in my case could be configured via the hosts "WebsitePanel". Maybe it can also be configured via FTP (chmod) but I didn't try that.

Maciej Over a year ago

@LouisSomers: You should add your comment as an answer to this question.

Collectives™ on Stack Overflow

Sqlite .NET and Entity Framework - "attempt to write a readonly database"

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related