search for: mydbnam

...has been started...) I am running MySQL on Mac OS X 10.4.2 with R2.4.1. I have tried to write a function using the RMySQL commands (below) and place them in .First of .RProfile: drv <- dbDriver("MySQL") dbcon <- dbConnect(drv, {other parameters present in my.cnf file} dbname="mydbName") DOES create a connection when entered into my R console individually but NOT when I place them in a function, i.e., condb <- function() { drv <- dbDriver("MySQL") dbcon <- dbConnect(drv, dbname="mydbName") dbGetInfo(db) } When the function is called, the...

I usually work with R on a windows querying data through RODBC from a postgresql db on a freebsd machine on my offcie lan. Now I have the chance to use R also on a linux gentoo client box and to connect to the same db. I know that I can install the unixodbc stuff and stick to RODBC, BUT my question is: Is there any more 'linuxish' way of querying a postgresql server from a client?

...where I have a couple of stored procedures. I know that the function for the stored procedures "is not yet implemented", but I was trying to get around the problem connecting like that: drv <- dbDriver("MySQL") con <- dbConnect(drv,user=MyUser, password=MyPasswd, dbname=MyDBName, host=MyHost, client.flag="196608" ) where 196608 is a combination of CLIENT_MULTI_RESULTS and CLIENT_MULTI_STATEMENTS as mentioned in the mysql_real_connect() documentation. Without these flags stored procedures calls do not run at all. I also do fetching the results in a loop - as...