Search results
27 maj 2020 · I would like to have a SQLite database in a file on my harddrive. Then I could access the database using a SqliteConnection. In my code, I call var db = new SqliteConnection("Data Source=testDB.sqlite"); to create the SqliteConnection. Then I call db.Open();.
29 maj 2017 · Activating "break on all exceptions" (in exceptions settings window) caused the weird 'unable to open database file' exception. Removing the [Table("TableName")] attributes on my entity classes caused some strange table creation behavior in the migration class.
23 sie 2009 · The solution is to make sure the directory containing the database file also has write access allowed to the process. In my case, running this command fixed the problem: sudo chown www-data .
23 lip 2024 · Ask a question I am seeing the following error sporadically. An error occurred using the connection to database 'main' on server 'path\to\db'. Exception: Microsoft.Data.Sqlite.SqliteException (0x80004005): SQLite Error 14: 'unable to ope...
4 gru 2021 · Fix it by tinkering with the environment variables or by configuring SQLite to store temp files in main memory: https://sqlite.org/tempfiles.html#the_sqlite_temp_store_compile_time_parameter_and_pragma
3 sie 2023 · My first problem is for some reason, the query! macro can't open the SQLite database. I have set the DATABASE_URL in the .env . Since I created the database and ran the migrations through sqlx CLI, the URL should be correct.
18 paź 2019 · Microsoft.Data.Sqlite.SqliteException: 'SQLite Error 14: 'unable to open database file'.' I have tried various different file name options, but this is the last I've tested: optionsBuilder.UseSqlite ($"Data Source=test.db"); I've tried to remove EF core from all the libraries involved.
