SQL logic error or missing database no such table

Question

I am trying to read all data from the table Condition in a local sqlite database. However I am getting this error:

SQL logic error or missing database no such table

The database is located in the same directory as the file that's calling it.

This is my code:

SQLiteConnection m_dbConnection = new SQLiteConnection("Data Source=myDatabase.sqlite;Version=3;");
m_dbConnection.Open();

try
{
    string sql = "select * from Condition";
    SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection);

    SQLiteDataReader reader = command.ExecuteReader();

    while (reader.Read())
        Console.WriteLine("Name: " + reader["name"] + "\tScore: " + reader["id"]);

    Console.ReadLine();
    return null;
}
catch (Exception exc)
{
    return null;
}
finally
{
    m_dbConnection.Close();
}

I would suggest you try a fully qualified path for your datasource (like 'C:/whatever/myDatabase.sqlite' to check if your code actually finds the database file. Your statement "same directory as the file that is calling it" sounds suspicious to me - how are you running your code? — H W
– H W, Commented Mar 25, 2015 at 8:18

Community · Accepted Answer · 2017-05-23 10:31:22Z

14

I have fixed the issue by using a absolute path instead of a relative path. thanks to Eternal21 https://stackoverflow.com/a/20083762/3483812

edited May 23, 2017 at 10:31

CommunityBot

11 silver badge

answered Mar 25, 2015 at 8:20

Jetpack

5881 gold badge6 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

horHAY Over a year ago

I was going to say in the comment above, as you run the program the directory becomes project/bin/debug, I'm guessing yours was in the directory with the solution file?

Cristina Alboni · Accepted Answer · 2015-03-25 08:20:52Z

9

The database should be located in your bin folder, or else specify the absolute path to the .sqlite file.

answered Mar 25, 2015 at 8:20

Cristina Alboni

1,0329 silver badges16 bronze badges

Comments

JavaLatte · Accepted Answer · 2021-03-12 12:36:40Z

0

I received the same error message on a linux system. When the database was created, the program was running as root: when the error occurred, the program was running as me. Basically, I didn't have write permission on the file.

answered Mar 12, 2021 at 12:36

JavaLatte

3866 silver badges20 bronze badges

Collectives™ on Stack Overflow

SQL logic error or missing database no such table

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related