System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: a74bfe85d072c86150ed47d4821989e8f6afcc25
Title: Exception when using network databases (not local one)
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: Connection Resolution: Duplicate
Last Modified: 2014-01-07 20:00:38
Version Found In: 1.0.90.0
User Comments:
anonymous added on 2014-01-07 15:55:56:
We have updated SQLite from 1.0.85.0 to 1.0.90.0 and now we encounter the following problem:
When we use a db.dat located in a network folder (something like \\pcName\folderName\db.dat) we get the following exception:
System.Data.SQLite.SQLiteException (0x80004005): unable to open database file
    bei System.Data.SQLite.SQLite3.Open(String strFilename, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)
    bei System.Data.SQLite.SQLiteConnection.Open()
    bei System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
    bei System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
    bei System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

When we use a local database (e.g. C:\folder\db.dat) everything seems to work fine. 
For test we tried to reuse the 1.0.85.0 version and the there are no problems when using databases in network folders.

Can you please take a look at this issue?

mistachkin added on 2014-01-07 20:00:38:
The initial backslashes in the file name must be doubled,
e.g. "\\\\server\share\file.db"

Also see duplicate ticket [bbdda6eae2].