[R] RSQLite basic
    Alexander Nervedi 
    alexnerdy at hotmail.com
       
    Mon Nov 27 23:33:55 CET 2006
    
    
  
Hi.
I am still trying to figure out how connection and RSQLIte function. When i 
run the following commands
library(RSQLite)
m <- dbDriver("SQLite", max.con = 25)
con <- dbConnect(m, dbname="sqlite.db")
on my windows laptop everthing works fine. For example:
>m <- dbDriver("SQLite", max.con = 25)
>con <- dbConnect(m, dbname="sqlite.db")
>version
               _
platform       i386-pc-mingw32
arch           i386
os             mingw32
system         i386, mingw32
status
major          2
minor          4.0
year           2006
month          10
day            03
svn rev        39566
language       R
version.string R version 2.4.0 (2006-10-03)
However, this gives all kinds of errors when I run it on a linux box and I 
am not sure what the error message is telling me. I thought I'd crave your 
indulgence and ask for advice.
>m <- dbDriver("SQLite", max.con = 25)
>con <- dbConnect(m, dbname="sqlite.db")
Error in sqliteNewConnection(drv, ...) : RS-DBI driver: (could not connect 
to dbname "sqlite.db"
)
>version
               _
platform       i686-pc-linux-gnu
arch           i686
os             linux-gnu
system         i686, linux-gnu
status
major          2
minor          4.0
year           2006
month          10
day            03
svn rev        39566
language       R
version.string R version 2.4.0 (2006-10-03)
thanks
- the nerdy.
_________________________________________________________________
Share your latest news with your friends with the Windows Live Spaces 
friends module.
    
    
More information about the R-help
mailing list