CODEWITHSUNDEEP
c++csqlite
user8024280
user8024280

Reputation:

SQLITE_CANTOPEN error when opening DB in READONLY mode

I want to open database as READONLY:

exit = sqlite3_open_v2( "database.db?immutable=1" , &db_ , SQLITE_OPEN_READONLY | SQLITE_OPEN_URI , nullptr );

but I am getting error: SQLITE_CANTOPEN, any idea why?

If I open it like this, open is successfull:

exit = sqlite3_open( "database.db" , &db_ );

Upvotes: 1

Views: 598

Answers (1)

BoBTFish
BoBTFish

Reputation: 19757

When using the SQLITE_OPEN_URI "the filename can be interpreted as a URI". However, for it to be treated as a URI, it must be prefixed with file:, else it will be treated as a normal filename.

So you are trying to open a file named database.db?immutable=1, which obviously doesn't exist. Note that with SQLITE_OPEN_READONLY "if the database does not already exist, an error is returned". Therefore the simplest fix is simply to make the string be file:database.db?immutable=1.

However I suggest you stick to only one method of providing special options; use the SQLITE_OPEN_URI flag, and put all the other options into the URI, like so: file:database.db?mode=ro&immutable=1.

(I realise that not all combinations of options are possible using only a single method, but in your case it is, so I say stick to one and then you don't need to worry about the way different methods interact).

SQLite has extensive documentation, and you can read all about opening databases here.

Upvotes: 1

Related Questions