Folks, I failed to create a connection to the database under MySQL DBMS in the R system via RMySQL's method dbConnection(...).
My setup is as follows: Microsoft Windows XP 5.1.2600 MySQL 4.1.9 R 2.0.1 DBI 0.1-8 RMySQL 0.5-5 Both of DBI and RMySQL packages were downloaded from bell lab: http://stat.bell-labs.com/RS-DBI/download/index.html My case in R is as follows: > library(DBI) > library(RMySQL) > mgr <- dbDriver("MySQL") > con <- dbConnect(mgr, user="root", pass="*******", host="localhost", > dbname="campus") Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not connect [EMAIL PROTECTED] on dbname "campus") What am I doing wrong with?... It is really an annoying question. Thank you very much for your help and patience. Yours truly, Willie Y CHEN -- ************************************ Decisioneering Pty Ltd PO Box 23 Doncaster, VIC 3108 Australia O: +61-3-98558661 H: +86-21-64205688 ______________________________________________ [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
