[R] RODBC to access a web server
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 odbcConnect. For local access I set up a dsn via the windows admin interface. I have tried to set up dsn for access to our web server by providing the IP address and user id and passwords but get the error below. Connection failed: [HY000] [MySQL] [ODBC 5.1 Driver]Host 'host86-180-150-32.range86-180.btcentralplus.com' is not allowed to connect to this MySQL server Thanks Brett __ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] RODBC to access a web server
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 access. I can't figure out how to set up odbcConnect. For local access I set up a dsn via the windows admin interface. I have tried to set up dsn for access to our web server by providing the IP address and user id and passwords but get the error below. Connection failed: [HY000] [MySQL] [ODBC 5.1 Driver]Host 'host86-180-150-32.range86-180.btcentralplus.com' is not allowed to connect to this MySQL server (1) That is not a 'web server': remote MySQL connections use TCP/IP but not 'the web'. (2) This really is not an R question. Try another client until you get the DSN right (and likely you need to talk to the server administrator, since quite likely you do not have permission to do what you are trying to do. And R-sig-db would be the appropriate R list, if any. Thanks Brett -- Brian D. Ripley, rip...@stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UKFax: +44 1865 272595 __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] RODBC to access a web server
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 rip...@stats.ox.ac.uk wrote: 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 access. I can't figure out how to set up odbcConnect. For local access I set up a dsn via the windows admin interface. I have tried to set up dsn for access to our web server by providing the IP address and user id and passwords but get the error below. Connection failed: [HY000] [MySQL] [ODBC 5.1 Driver]Host 'host86-180-150-32.range86-180.btcentralplus.com' is not allowed to connect to this MySQL server (1) That is not a 'web server': remote MySQL connections use TCP/IP but not 'the web'. (2) This really is not an R question. Try another client until you get the DSN right (and likely you need to talk to the server administrator, since quite likely you do not have permission to do what you are trying to do. And R-sig-db would be the appropriate R list, if any. Thanks Brett -- Brian D. Ripley, rip...@stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595 __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. -- Oliver Ruebenacker, Bioinformatics and Network Analysis Consultant President and Founder of Knowomics (http://www.knowomics.com/wiki/Oliver_Ruebenacker) Consultant at Predictive Medicine (http://predmed.com/people/oliverruebenacker.html) SBPAX: Turning Bio Knowledge into Math Models (http://www.sbpax.org) __ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
