General

Re: strange Error : no such table : ....

amw403 — Thu, 24 Dec 2009 16:53:56 GMT

sir,

what do you mean by

Data Source=" + Path.GetDirectoryName(Application.ExecutablePath)" + Databasename

ex. if my datasource is in c:\visual studio\myproj\bin\debug\ and the file name si demo.db ( c:\visual studio\myproj\bin\debug\demo.db)

my question is that what should i type in the Data Source?

Data Source = " "

Re: strange Error : no such table : ....

indiekiduk — Fri, 18 Jan 2008 12:35:50 GMT

Should I really be going into the dataset code behind file and editing the path to make it use the relative magic word? [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private void InitConnection() { this._connection = new global::System.Data.SQLite.SQLiteConnection(); this._connection.ConnectionString = "data source="|DataDirectory|db.s3db""; }

Re: strange Error : no such table : ....

Robert Simpson — Mon, 18 Sep 2006 02:57:33 GMT

I don't really know why the file dialog changes the current directory -- IMO it's a bug in .NET, but apparently the file dialog was designed that way for some ridiculous reason.

Robert

Re: strange Error : no such table : ....

netplayer — Sun, 17 Sep 2006 16:36:26 GMT

Suggestion

i forgot to suggest, that the exception maybe
told me that the database didnt exist. So I and maybe other mates
would better find the bug.

greets

thuy

Re: strange Error : no such table : ....

netplayer — Sun, 17 Sep 2006 16:30:01 GMT

thx a lot for fast reply and solution.
i tested it, and it works i am so happy, bcause i thought i did
a mistake and spend this weekend to find the bug.
thanx a lot again.Thats a waste of time.

its quite simple the path, i try

Data Source=" + Path.GetDirectoryName(Application.ExecutablePath)" + Databasename

and it works.

Why does the path change at runtime thru the filedialog?

thuy

Re: strange Error : no such table : ....

Robert Simpson — Sun, 17 Sep 2006 15:33:13 GMT

If you are closing and opening a connection, and the connection string contains a relative path to the database, and you are using the Open File dialog, then the problem is that the Open File dialog is changing your CurrentDirectory and the database's relative path no longer points to the same place it was pointing when the application first started.

You can change your connection string to "Data Source=|DataDirectory|mydatabase.db" instead, and |DataDirectory| will be switched at runtime to your application's designated data directory, or if none was configured, the application's folder.

Robert

strange Error : no such table : ....

netplayer — Sun, 17 Sep 2006 09:51:52 GMT

hi to all,

i have a very strange error:
the ado provider works fine till i add a filedialog to my form.
i have a form with textboxes. i bind these to dataset.
But after i add a filedialog to my form, start the app, select a file with the dialog
press save to commit to sqlite3, i got

"SQLite error no such table: foo SQLiteException caught."

after this exception i cant open a connection any more. i need to start the app again.
the table exist of course. but this happens only when i select a file with a filedialog.

Someone has the same error?