Re: [R] RODBC to access a web server

2012-06-21 Thread Oliver Ruebenacker
Hello Brett, My guess is you did not set the access rules on the MySQL server to allow connections from this host. Take care Oliver On Thu, Jun 21, 2012 at 1:29 PM, Prof Brian Ripley wrote: > On 21/06/2012 17:17, Brett Robinson wrote: >> >> Hi, I have tried to figure this out f

Re: [R] RODBC to access a web server

2012-06-21 Thread Prof Brian Ripley
On 21/06/2012 17:17, Brett Robinson wrote: Hi, I have tried to figure this out from the help files and lists but not managed it I can access a local MySQL database from R running on my Windows XP PC. What I want to do is access a MySQL database on a linux web server, for which I have admin ac

[R] RODBC to access a web server

2012-06-21 Thread Brett Robinson
Hi, I have tried to figure this out from the help files and lists but not managed it I can access a local MySQL database from R running on my Windows XP PC. What I want to do is access a MySQL database on a linux web server, for which I have admin access. I can't figure out how to set up odbc