[R] RODBC to access a web server

[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 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,                  ripley at 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