"Steve Rogers" wrote...
On 9/23/2014 10:57 PM, Joe Mistachkin wrote:
Steve Rogers wrote:
Reading in order, it says that:
SQLiteDb.LDb3.PrepareCommand threw an exception with the message
'unable to open database file'
Is the database file name a UNC path? If so, the number of leading
backslashes must be doubled (i.e. four leading backslashes are now
required), e.g.:
//
// NOTE: The C# compiler itself needs the backslashes escaped
// as well, hence there are 8.
//
string fileName = "\\\\\\\\server\\share\\path\\to\\database.db";
--
In my test today, the path was C:\Users\Public because I was installing
on the machine that will be the machine to hold the database file.
I'll need to take these comments into account when I get to a fully
qualified UNC name on the other computers.
I have found out that using UNC paths vs a mapped drive to a server, is much
slower. Specially if you are going to use a database shared amoungst other
folks. I would suggest a test on both scenario (UNC path and mapped drive)
and place some times on the same calls and you'll see the differences.
Heck, you can see the difference by copying a file. Ihth.
josé
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
