Read-only database file access...

[jpapp]

Hi,

We are using dotConnect for SQLite, version 3.80.314.0 of the Professional edition and are having difficulties with accessing read-only databases.

Does this version (or any later version for that matter) support some type of shared read only connection string to allow SQLite to work with read-only databases?

We double checked the documentation and did not see any mention nor did we find any reference in the DLLs using Reflector (though we could have missed it since it is obfuscated). The SQLiteConnectionStringBuilder also does not have any properties that seem to address this functionality.

For this to work you would need to support the SQLITE_OPEN_READONLY bit flag to the sqlite3_open_v2 API.

Any information on this would be greatly appreciated.

Thanks much,
James.

[Pinturiccio]

We are investigating the possibility of implementing the connection string parameter for connecting to a read-only database.

[Pinturiccio]

We have implemented Read-Only connection string parameter for establishing a connection in the read-only mode. We will post here when the corresponding build of dotConnect for SQLite is available for download.

[jpapp]

You guys are the best; I recommend your product for SQLite whenever the subject comes up.

Thanks much,
James.

[Pinturiccio]

The new build of dotConnect for SQLite 4.2.114 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/sqlite/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=25197