System.Data.SQLite

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?

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

 

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

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

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

 

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""; }

 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 = " "

The same error occurs in the following situation too:

You add .db file to your project. Then when you run your c# project with debugger, empty db. file is copied into bin/debug folder of the project folder. Your running application looks for tables in the empty database and returns error: "no such table..."

To solve the problem, either copy your .db file to bin/debug folder of the project folder manually before running the project. Or, do the following:

Rigth click the database file in the solution explorer of the visual studio and select "Properties".
Set "Copy to Output Directory" to "Copy always".
Then run the project with connection string like: "Data Source=Something.db; Version=3;"