a...@zator.com wrote...
---- Mensaje original ----
De: "Chris" <developm...@thegifnet.com>
Para: <sqlite-users@sqlite.org>
Fecha: Sat, 6 Sep 2014 23:46:19 -0500
Asunto: [sqlite] Does the Connection string support UNC paths?
I am old database programmer that just came across SQLite and am working
on
a small project for a PVR that uses SQLite as it's db provider. I try
specifying a UNC path to the database for the datasource in the connection
string and I get the following error, "unable to open database file". .
When I look at the exception generated, I see an errorcode = 14. However,
if I map a network drive, I can open the file and work with it. I am
running Windows 7 x64 Pro and system.data.sqlite version 1.0.93.0 with dot
net framework 4.0 and Visual Studio 2010.
Obviously SQLite supports UNC paths because I am using SQLite database
browser to open the same database using a UNC path.
Also, a full pathname, can start with a double backslash (\\), indicating
the global root, followed by a server name and a share name to indicate
the path to a network file server.
Just a little suggestion: UNC paths are slower than connecting that same
path to a drive. If you are going to use it a lot, I suggest for you to
connect that path to a drive and it will be much faster. We have a system
using SQLite with a SharedDB and connecting that path to a drive is much
faster. Ihth.
josé
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
