[R] RODBC to access a web server

[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
<ripley at 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,                  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
>
>
> ______________________________________________
> R-help at 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)