Re: [R] Query about RODBC to access MySQL from Windows

From: Prof Brian Ripley <ripley_at_stats.ox.ac.uk>
Date: Tue, 15 May 2007 06:24:08 +0100 (BST)

Please, you have shown no context here at all: your readers have no idea what 'exactly the same problem' is nor whom you are replying to, and this thread is not recent.

On Mon, 14 May 2007, James Curran wrote:

> I had exactly the same problem. I solved it by switching back to the early
> version of MySQL Connector/ODBC, 3.51.

The current version of the MySQL ODBC driver _is_ 3.51, far from being the 'early version'. MySQL Connector/ODBC 5.0 is still a beta.

> Interestingly, it was only the returning of results that wasn't working.
> Queries like "create table" and "insert ... select" worked just fine.

And that issue is covered for other buggy drivers in the RODBC documentation.

-- 
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_stat.math.ethz.ch 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.
Received on Tue 15 May 2007 - 05:31:10 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Tue 15 May 2007 - 06:31:13 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.