Can't open Sqlite database in read-only mode

Question

I have a Sqlite database that I include with my MonoTouch app. It has worked fine for me so far, but now I want to open it in read-only mode rather than read-write.

So I have changed the connection string to include 'Read Only=True', but when I call Open(), I get the following error:

Library used incorrectly (at Mono.Data.Sqlite3.Open)

If I dig into the exception it shows

_errorCode = Misuse

and that's about all the info it gives.

Here's the code:

var _conn = new SqliteConnection("Data Source=db/sampleDb;Read Only=True");
_conn.Open ();

poupou · Accepted Answer · 2011-12-22 14:43:24Z

10

You found a bug in Mono.Data.Sqlite.dll.

The Create flag is appended (by default) before the ReadOnly flag is parsed and set. The resulting flag is invalid and sqlite reports an error.

I will fix this for future releases (of Mono and MonoTouch...). If this blocks you then please open a bug report on http://bugzilla.xamarin.com and I'll attach a fixed assembly (with instructions to replace the existing one) to the bug report.

answered Dec 22, 2011 at 14:43

poupou

43.6k6 gold badges81 silver badges176 bronze badges

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

2 Comments

vlad259 Over a year ago

Very useful to know, thanks a lot. I'm not exactly blocked by it but I would like to open a bug to track the status - will do so now.

vlad259 Over a year ago

In case this is of use to people, here is a link to the bug I raised: bugzilla.xamarin.com/show_bug.cgi?id=2721

hugo · Accepted Answer · 2019-05-18 21:57:21Z

2

This worked for me (aspnet core):

var _conn = new SqliteConnection("Data Source=db/sampleDb;mode=ReadOnly");

answered May 18, 2019 at 21:57

hugo

1,8592 gold badges19 silver badges47 bronze badges

Comments

IanNorton · Accepted Answer · 2011-12-22 11:44:54Z

1

Have you tried?:

var _conn = new SqliteConnection("Data Source=db/sampleDb;mode=ro");

answered Dec 22, 2011 at 11:44

IanNorton

7,3022 gold badges27 silver badges29 bronze badges

Comments

ken2k · Accepted Answer · 2011-12-22 12:21:59Z

0

Your code is correct, I just tried it (not using MonoTouch) and it worked for me.

Do you have the latest version of System.Data.SQLite.dll? If yes, then maybe it's a problem related to MonoTouch.

answered Dec 22, 2011 at 12:21

ken2k

49.2k12 gold badges119 silver badges179 bronze badges

Collectives™ on Stack Overflow

Can't open Sqlite database in read-only mode

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related