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.
Re: [R] RODBC ERROR on Rcmdr install
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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.
Re: [R] RODBC ERROR on Rcmdr install
Dear Sarosh, 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. You should, I believe, be able to install and use the Rcmdr package on your system without RODBC. I hope this helps, John John Fox Department of Sociology McMaster University Hamilton, Ontario Canada L8S 4M4 905-525-9140x23604 http://socserv.mcmaster.ca/jfox -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sarosh Jamal Sent: Friday, September 29, 2006 11:53 AM To: R-help@stat.math.ethz.ch Subject: [R] RODBC ERROR on Rcmdr install I've been trying to install the RODBC dependency for Rcmdr on Rv2.4 on a SunOS9 system. It claims not to be able to create gcc output files (executables) for the installation. This is puzzling since I've been able to install other packages with the same PATH variables and all. Feedback would be much appreciated. Thank you! Sarosh Jamal Geo Computing IT Specialist, Department of Geography University of Toronto at Mississauga e: [EMAIL PROTECTED] p: (905) 569-4497 __ 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.