> Can you clarify: are you trying to connect to a mySQL database, or to a sqlite database? 

It is a sqlite database.
Thanks for pointing that out!

Now it works just like in python ;).


con <- dbConnect(SQLite(), dbname="xy.sqlite")

res <- dbSendQuery(conn = con, "SELECT * FROM table1 WHERE x = y")
data <- fetch(res, n = -1)

dbCommit(con)
dbDisconnect(con)


thanks!



On May 16, 2013, at 23:51 , Sarah Goslee <sarah.goslee@gmail.com> wrote:

> Hi Martin,
> 
> Can you clarify: are you trying to connect to a mySQL database, or to a sqlite database? They're not at all the same thing, and I can't tell from your question which you're after. 
> 
> You need either RMySQL, or if you actually want an sqlite database, RSQLite or sqldf.
> 
> Sarah
> 
> On Thursday, May 16, 2013, Martin Batholdy wrote:
> Hi,
> 
> I would like to access a local mysql database.
> 
> In python using the sqlite3 library it is quite straightforward. I just have to pass the path to the sqlite-file;
> sqlite3.connect('.../xy.sqlite')
> 
> Is there something similar in R (or specifically in the RMySQL package)?
> 
> 
> It seems like I have to use the MySQL function in the RMySQL package in order to ...
> "initializes a MySQL client. It returns an driver object that allows you to connect to one or several MySQL servers."
> 
> 
> But is that also possible with a local mySQL database?
> Can't I just provide the information where to find the sqlite file and then open it?
> 
> 
> sorry if this are stupid questions,
> I am not very familiar with databases and just have to access a database on a shared network drive, which worked fine in python but seems to be not so straightforward in R.
> 
> 
> I am grateful for any suggestions!
> 
> 
> 
> 
> -- 
> Sarah Goslee
> http://www.stringpage.com
> http://www.sarahgoslee.com
> http://www.functionaldiversity.org


	[[alternative HTML version deleted]]

