definivelty confused about sqlite as embedded database
-
Hello good fellas 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">here</a> based on this tutorials found <a href="http://decoding.wordpress.com/2009/01/14/using-sqlite-with-net/">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 <code><connectionStrings> <add name="embcon" connectionString="Data Source=database\iagency.db;Version=3;"/> </connectionStrings></code> but if the iagency.db is inside the root folder there is no problem at all.app.config like <code><connectionStrings> <add name="embcon" connectionString="Data Source=iagency.db;Version=3;"/> </connectionStrings></code> 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.
eager to learn
-
Hello good fellas 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">here</a> based on this tutorials found <a href="http://decoding.wordpress.com/2009/01/14/using-sqlite-with-net/">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 <code><connectionStrings> <add name="embcon" connectionString="Data Source=database\iagency.db;Version=3;"/> </connectionStrings></code> but if the iagency.db is inside the root folder there is no problem at all.app.config like <code><connectionStrings> <add name="embcon" connectionString="Data Source=iagency.db;Version=3;"/> </connectionStrings></code> 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.
eager to learn
i just wanted to precise that i can connect to the database though the server explorer.and there is no table created from visual studio queries.but the table's data can be displayed on a grid when i run it.weird!! hanging on your replies, i can't find anything meaningful to my case.thanks
eager to learn