Re: [R] Accessing MySQL Database in R

2011-01-21 Thread Sascha Vieweg
Bleu. Re: Accessing MySQL Database in R Jan 18, 2011; 12:10am — by djmuseR [User is online] djmuseR Hi: Because R does not have a direct interface to MySQL? You need to load a communication package - the two most common ones are RODBC and RMySQL. The former requires that you register your

Re: [R] Accessing MySQL Database in R

2011-01-20 Thread PtitBleu
for you. Good luck, Ptit Bleu. Re: Accessing MySQL Database in R Jan 18, 2011; 12:10am — by djmuseR [User is online] djmuseR Hi: Because R does not have a direct interface to MySQL? You need to load a communication package - the two most common ones are RODBC and RMySQL. The former requires

Re: [R] Accessing MySQL Database in R

2011-01-20 Thread Spencer Graves
(connection=SERVER=localhost;DRIVER=MySQL ODBC 5.1 Driver;DATABASE=my_database;UID=root;PWD=my_password;case=tolower) resultdb-sqlQuery(ch,SELECT * from my_table) odbcClose(ch) Try to modify them for your case. I hope it will work for you. Good luck, Ptit Bleu. Re: Accessing MySQL Database in R

Re: [R] Accessing MySQL Database in R

2011-01-19 Thread Uwe Ligges
Folks, 1. can you pelase cite the messages you are repsonding to? 2. Can you please include the original poster of the question who is not necessarily subscribed to the list? Thanks, Uwe Ligges On 18.01.2011 09:52, Joel wrote: You could try useing '127.0.0.1' instead of 'localhost' and

Re: [R] Accessing MySQL Database in R

2011-01-18 Thread Joel
You could try useing '127.0.0.1' instead of 'localhost' and see if that works. -- View this message in context: http://r.789695.n4.nabble.com/Accessing-MySQL-Database-in-R-tp3221264p3221291.html Sent from the R help mailing list archive at Nabble.com

[R] Accessing MySQL Database in R

2011-01-17 Thread schlafly
'@'localhost' (using password: YES) Does anyone know why these aren't equivalent? -- View this message in context: http://r.789695.n4.nabble.com/Accessing-MySQL-Database-in-R-tp3221264p3221264.html Sent from the R help mailing list archive at Nabble.com

Re: [R] Accessing MySQL Database in R

2011-01-17 Thread Dennis Murphy
' (using password: YES) Does anyone know why these aren't equivalent? -- View this message in context: http://r.789695.n4.nabble.com/Accessing-MySQL-Database-in-R-tp3221264p3221264.html Sent from the R help mailing list archive at Nabble.com. __ R-help