Hi Seth, I didn't realize that this conversation went off the list with Bentilon. It turns out the source of the problem was that I was trying to write into a linux sub-directory to which I didn't have write permissions. I am able to read and write now using dbWriteTale()
thanks for suggesting using sessionInfo() - i didn't know of the command. Al >From: Seth Falcon <[EMAIL PROTECTED]> >To: "Alexander Nervedi" <[EMAIL PROTECTED]> >CC: [email protected] >Subject: Re: [R] RSQLite basic >Date: Mon, 27 Nov 2006 16:47:40 -0800 > >Hi Alexander, > >"Alexander Nervedi" <[EMAIL PROTECTED]> writes: > > 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" > > ) > >What is your working directory when you run this command? getwd() >will tell you. You should verify that you have write access there. > >Does sqlite.db already exist? If so, was it created with a different >version of sqlite than you are running? > >Which brings me to: > >it would be helpful to see the output of sessionInfo() so we know what >versions of DBI and RSQLite you are running. > >+ seth _________________________________________________________________ Share your latest news with your friends with the Windows Live Spaces friends module. ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
