Displaying 3 results from an estimated 3 matches for "mydbname".
Did you mean:
my_dbname
2007 Aug 11
1
Connecting to database on statup
...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 d...
2005 Jan 13
2
R, postgresql, windows & bsd
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?
2006 Oct 27
0
RMySQL and stored procedures
...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 s...