C# , SQLite - what is "Data Source cannot be empty. Use :memory: to open an in-memory database" why i get this

Question

Hi ,

I recently converted my SQL Server database into SQLite db . But when I try to open my SQLite using .Open() it throw me this error

Data Source cannot be empty.  Use :memory: to open an in-memory database

Edit: added connection string:

ConnectionString = @"Data Source= D:\XXX.db;Version=3;
connection = new SQLiteConnection(connectionString); 
connection.Open();

Why do i get this . I converted the same SQL Server database to SQL CE and mySQL I didnt get these error .. Any help appriciated .

Answer 1

Because your Data Source is empty. Add the Data Source paramater to your connection string. before opening the Sqlite database.

Answer 2

You haven't provided a data source name, aka where the sqlite file exists.