Re: [R] RODBC ERROR on Rcmdr install

From: John Fox <jfox_at_mcmaster.ca>
Date: Mon 02 Oct 2006 - 13:10:57 GMT


Dear Vittorio,

Thanks for the clarification. This raises two questions: (1) If a *nix system has an ODBC driver, can one then read Excel, Access, and dBase data sets via RODBC (which is what the Rcmdr menu item in question provides for)? (2) If so, is there a way for me to detect whether unixODBC is present, or would I have to rely, e.g., on a user-set option?

I'm moving this message to the r-devel list.

Regards,
 John



John Fox
Department of Sociology
McMaster University
Hamilton, Ontario
Canada L8S 4M4
905-525-9140x23604
http://socserv.mcmaster.ca/jfox

> -----Original Message-----
> From: r-help-bounces@stat.math.ethz.ch
> [mailto:r-help-bounces@stat.math.ethz.ch] On Behalf Of vittorio
> Sent: Saturday, September 30, 2006 12:40 PM
> To: r-help@stat.math.ethz.ch
> Subject: Re: [R] RODBC ERROR on Rcmdr install
>
> Alle 22:55, venerd́ 29 settembre 2006, John Fox ha scritto:
> > As I understand it, RODBC isn't useful on non-Windows
> systems, since
> > the necessary ODBC drivers aren't available. (Someone will
> correct me,
> > I'm sure, if I don't have that entirely straight.) The
> RODBC package
> > is used in the Rcmdr to read Excel and some other files
> under Windows;
> > in the latest version of the Rcmdr, you won't even see this
> menu item
> > in non-Windows systems.
>
> As a matter of fact RODBC can be profitably used under *nix
> OS together with unixODBC to connect to many DBs.
> I've been using RODBC with unixODBC on linux, freebsd and win
> xp to connect smoothly to postgresql, mysql and oracle
> (somewhat tricky to me under *nix, you need ** to buy ** a
> driver) and I know that connections are possible to many
> other *nix DBs under *nix itself.
>
> Ciao
> Vittorio
>
> ______________________________________________
> R-help@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.



R-help@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 Mon Oct 02 23:24:44 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Mon 02 Oct 2006 - 14:30:07 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.