title: SQLIte unable to open database
body: <p>I just started working on a sample application that only calls some tables on my SQLite database, and I have managed to solve other issues that have happened except this one.  </p>
  
  <p>Although I have searched for this, none of the suggested solutions for the connectionstring, permission issues and etc seem to be valid and working for me.  For the permissions, I added the <code>Everyone</code> user with full control, and I still get the same error.</p>
  
  <p>Below is the code that I am trying to execute:</p>
  
  <pre><code>// calling function
  void getRecords2()
      {
          MySqlLite.DataClass ss = new MySqlLite.DataClass();
          DataTable dt = ss.selectQuery("select * from english_words"); 
      }
  
  // the SQLite class that execute the code
  using System.Data;
  using System.Data.SQLite;
  
  namespace MySqlLite
  {
      class DataClass
      {
          private SQLiteConnection sqlite;
  
          public DataClass()
          {            
              //This part killed me in the beginning.  I was specifying "DataSource"
              //instead of "Data Source"
              sqlite = new SQLiteConnection(@"Data Source=C:\testwork\db\MrPick.sqlite3.db;Version=3;FailIfMissing=True");
  
          }
  
          public DataTable selectQuery(string query)
          {
              SQLiteDataAdapter ad;
              DataTable dt = new DataTable();
  
              try
              {
                  SQLiteCommand cmd;
                  sqlite.Open();  //Initiate connection to the db
                  cmd = sqlite.CreateCommand();
                  cmd.CommandText = query;  //set the passed query
                  ad = new SQLiteDataAdapter(cmd);
                  ad.Fill(dt); //fill the datasource
  
                  cmd.Dispose();
                  sqlite.Dispose();  
  
              }
              catch (SQLiteException ex)
              {
                  //Add your exception code here.
              }
              sqlite.Close();
              return dt;
          }
      }
  }
  </code></pre>
  
  <p>Note: I used the following assembly:</p>
  
  <pre><code>ADO.NET SQLite Data Provider
  Version 1.0.82.0 September 3, 2012
  Using SQLite 3.7.14
  Originally written by Robert Simpson
  Released to the public domain, use at your own risk!
  Official provider website: http://system.data.sqlite.org/
  </code></pre>
  
  <p>I really appreciate your help on this. </p>