title: How can I open database file in R?
body: <p>I downloaded a database file from <a href="https://i.stack.imgur.com/oyePj.png" rel="nofollow noreferrer">here</a> </p>
  
  <p><a href="https://github.com/iDEP-SDSU/idep" rel="nofollow noreferrer">https://github.com/iDEP-SDSU/idep</a></p>
  
  <p>I changed the file name to shorter name to successfully unzip the file.
  Then I changed the file name again to 'convertIDs.db' </p>
  
  <p>I am trying to connect the database to R using RSQLite package &amp; dbConnect function. </p>
  
  <p>code :</p>
  
  <pre><code>library(RSQLite, verbose=FALSE)
  setwd('C:/idep/')
  sqlite &lt;- dbDriver('SQLite')
  convert &lt;- dbConnect(sqlite,paste0(datapath,"convertIDs.db"),flags=SQLITE_RO) # read only mode
  </code></pre>
  
  <p>but this produces warning message like:</p>
  
  <blockquote>
    <p>"Couldn't set synchronous mode:file is not a database"</p>
  </blockquote>
  
  <p>How could i make R recognize the file as database file?</p>
  
  <p><a href="https://i.stack.imgur.com/q7rfI.png" rel="nofollow noreferrer">Error message</a></p>
  
  <p>I have checked the file type - I checked the attribute of the file "Data Base File(.db)" </p>
  
  <p><a href="https://i.stack.imgur.com/TGrC6.png" rel="nofollow noreferrer">File type</a></p>
  
  <p>I checked if the file does exist on the path with file.exists("./data/data96/convertIDs.db"), this returned TRUE.</p>
  
  <p>Is there any solution?</p>