[R] RSQLite basic

[Alexander Nervedi]

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 <sfalcon at fhcrc.org>
>To: "Alexander Nervedi" <alexnerdy at hotmail.com>
>CC: r-help at stat.math.ethz.ch
>Subject: Re: [R] RSQLite basic
>Date: Mon, 27 Nov 2006 16:47:40 -0800
>
>Hi Alexander,
>
>"Alexander Nervedi" <alexnerdy at hotmail.com> 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.