vendredi 27 novembre 2015

connecting to a sqlite db with C# - either all tables where deleted or it returns "unsupported file format"

I tried to connect to a existing SQLite database using C#.

If I connect to the database like following, it works but all tables in this db are deleted.

SQLiteConnection sqlite_conn;
sqlite_conn = new SQLiteConnection(@"Data Source = C:\Ts3UserTool\Workspace\ts3server.sqlitedb; Version = 3 ; New = True; Compress = True;");
sqlite_conn.Open();

And if I i change the attribute New to "False", I get an "unsupported file format" error.

Aucun commentaire:

Enregistrer un commentaire