Databases
StackOverflow2013
Postsdbo
POsqlite is given me headache in my C#2.0 windows application
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POsqlite is given me headache in my C#2.0 windows application
    text
    copied!<p>I'm struggling since this morning about this sqlite thing.after reading some good tutorials i decided to use it as my embedded database in my winform application. i downloaded SQLite-1.0.61.0-setup that install the system.datal.sqlite for me and downloaded the firefox plugin sqlite manager and another management tool called wxSQLitePlus found <a href="http://cfred.free.fr/wxsqliteplus.php" rel="nofollow noreferrer">here</a> based on this tutorials found <a href="http://decoding.wordpress.com/2009/01/14/using-sqlite-with-net/" rel="nofollow noreferrer">here</a> (just being explicit) Hoping i'm not posting any stupid stuff that will be ignored, here are my 2 challenges. the first challenge is that i can't reference the database inside a folder let'say database i have exception "Unable to open the database file".my app.config is as follow</p> <pre><code>&lt;connectionStrings&gt; &lt;add name="embcon" connectionString="Data Source=database\iagency.db;Version=3;"/&gt; </code></pre> <p></p> <p>but if the iagency.db is inside the root folder there is no problem at all.app.config like</p> <pre><code>&lt;connectionStrings&gt; &lt;add name="embcon" connectionString="Data Source=iagency.db;Version=3;"/&gt; </code></pre> <p></p> <p>the second chalenge is that object created via tools such as either firefox plugin or wxsqlite+ cannot be queried inside visual studio 2005 that i'm using.if it's a table when queried , i have an excetion the object doesn't exist even though both tools displays the same data. and inversly table created by queries inside visual studio cannot be viewed by the tools. so what's the deal? is it a memory stuff or i'm just missing some points? can enybody explain what is happening ?Thanks for reading.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload