System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: fdc7447335fe61d70bba4e00a629e35cd2c15117
Title: Can let sqlite file path support LAN address?
Status: Closed Type: Incident
Severity: Important Priority: Medium
Subsystem: Connection Resolution: Duplicate
Last Modified: 2013-12-30 08:53:40
Version Found In: 1.0.87.0
User Comments:
anonymous added on 2013-12-30 08:28:53: (text/x-fossil-plain)
Hi, I'm use System.Data.SQLite and use Entity framework use it on C#(net4.0 visual studio 2012)

Usually when we open sqlite, we just need set the "data source=path", for example:

entity.ProviderConnectionString = "data source=C:\\data.db";

When I'm use it on LAN. when my LAN IP address is 192.168.1.9. I share the sqlite database file data.db. 

But now the problem is I can't use :  "data source=\\\\192.168.1.9\\data.db" path to access the sqlite database.

The only way is use Map a Drive feature to handle this problem. I mean Map the LAN address 192.168.1.9 to Z:\  ,  Then we can use "Z:\\192.168.1.9" path

But I think that's a very bad way, We can't let all customer every time change IP or change machine Remap the path.

So can you guys just let it support the LAN address(I know use sqlite on LAN is Not recommended, but some times we still need that simple , fast, fool way to handle some problem)

Thanks

mistachkin added on 2013-12-30 08:53:40: (text/x-fossil-plain)
See duplicate ticket [bbdda6eae2].

In order to open a database file on a network share, four leading backslash
characters are now required.