Re: [R] RODBC ERROR on Rcmdr install

From: vittorio <vdemart1_at_tin.it>
Date: Sat 30 Sep 2006 - 17:40:28 GMT

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. Received on Mon Oct 02 17:44:59 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 - 13: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.