All the queries work well for me but when I try to do a insert in SQLite I get the following error:
attempt to write to readonly database
All the queries work well for me but when I try to do a insert in SQLite I get the following error:
attempt to write to readonly database
The error was caused because my database was .SQLite and the solution was to change it to .db Thanks for the help
It seems that the problem you have is that you create the database without security, so when you try to connect to it, it does not leave you.
You should indicate a password when creating the database and in the connection string indicate the password:
SQLiteConnection conn = new SQLiteConnection("DataSource=MyDatabase.sqlite;Version=3;");
conn.SetPassword("password");
conn.open();
I hope it helps you.