title: R connection to sqlite
body: <p>Unable to connect to sqlite from R.  Sqlite3 is installed on the linxu server and am able to create/modify. But R isn't connecting. </p>
  
  <pre><code>library(dplyr)
  library(RSQLite)
  
  &gt; db &lt;- src_sqlite("my_db.sqlite3", create = TRUE)
  Error in .local(drv, ...) : Could not connect to database:
  unable to open database file
  </code></pre>
  
  <p>Able to connect to sqlite from command line</p>
  
  <pre><code>@ubuntu:~$ sqlite3
  SQLite version 3.8.2 2013-12-06 14:53:30
  Enter ".help" for instructions
  Enter SQL statements terminated with a ";"
  sqlite&gt; 
  </code></pre>
  
  <p>Here is the sessionInfo</p>
  
  <blockquote>
    <p>sessionInfo()
        R version 3.2.2 (2015-08-14)
        Platform: x86_64-pc-linux-gnu (64-bit)
        Running under: Ubuntu 14.04.1 LTS</p>
  </blockquote>
  
  <pre><code>locale:
   [1] LC_CTYPE=en_US.UTF-8       LC_NUMERIC=C              
   [3] LC_TIME=en_US.UTF-8        LC_COLLATE=en_US.UTF-8    
   [5] LC_MONETARY=en_US.UTF-8    LC_MESSAGES=en_US.UTF-8   
   [7] LC_PAPER=en_US.UTF-8       LC_NAME=C                 
   [9] LC_ADDRESS=C               LC_TELEPHONE=C            
  [11] LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C       
  
  attached base packages:
  [1] stats     graphics  grDevices utils     datasets  methods   base     
  
  other attached packages:
  [1] RSQLite_1.0.0 DBI_0.3.1     dplyr_0.4.3  
  
  loaded via a namespace (and not attached):
  [1] magrittr_1.5   R6_2.1.1       assertthat_0.1 parallel_3.2.2 tools_3.2.2   
  [6] Rcpp_0.12.1   
  &gt; 
  </code></pre>