Connect PC to SQLite db located in windows ce storage
<p>I have a SQLite database file in my PC. I have an offline application on my Windows CE. This app gets data from this file and updates them. The process is here:</p>

<p>1- initialize SQLite db file (<strong>in PC</strong>)</p>

<p>2- Copy db file to windows CE storage (<strong>in PC</strong>)</p>

<p>3- Some process on data (<strong>in Windows CE</strong>)</p>

<p>4- Copy db file to PC (in order to access the data) (<strong>in PC</strong>)</p>

<p>5- Do main app processes (<strong>in PC</strong>)</p>

<p>After a while the db records become large. I used indices and <code>vacuum</code> command on db and the problem solved.</p>

<p>Again after a while the db records become huge. Now copying the file takes long time. I want to remove steps 2 and 4 in order to speed up Get/Send events in PC app.</p>

<p>Connection string is my problem. Here is my code:</p>

<pre><code>private string ConnectionString_SQLite = "";
public SQLite_()
    {
        string Data_Source_SQLite = `@"\\\Asset\System.db"`;
        ConnectionString_SQLite = "Data Source=" + Data_Source_SQLite + ";Version=3;";
    }
</code></pre>

<p>I tested these data sources in connection string:</p>

<ul>
<li><code>@"\Asset\System.db"</code></li>
<li><code>@"\\Asset\System.db"</code></li>
<li><code>@"\\\Asset\System.db"</code></li>
<li><code>@"Computer\POINTMOBILE PM60\\\Asset\System.db"</code> (copied from windows explorer address bar)</li>
</ul>

<p>Is there anyway to access the file located in path <code>\\Asset\</code>?</p>