2

I encountered an error while I was trying to connect to database using RSQLite. The following is my code:

 library(DBI)
  library(RSQLite)

  con = dbConnect(SQLite(), dbname="C:/database/Forms/20183.sqlite")
  dbSendQuery(conn=con,
              "CREATE TABLE compsubm
              (FILENAME TEXT, COMLSUBFILE TEXT)")

And the error message is:

Error in connection_connect(dbname, loadable.extensions, flags, vfs) :
Could not connect to database:
unable to open database file

I tried both R 3.5.1 and R 3.3.3, and, R studio is run as the administrator. Could you let me know how to fix this error?

rkta
  • 3,959
  • 7
  • 25
  • 37
C. Bae
  • 21
  • 1

0 Answers0