I have now read the README file which I should have done before. :-[ Sorry. To summarize: - Install the odbc connector driver (3.51) - Set up the dsn in the file .odbc.ini - It works beautifully and RODBC is super!
Prof Brian Ripley wrote: > yOn Mon, 28 May 2007, Bill Szkotnicki wrote: > >> Hello, >> >> I have installed R2.5.0 from sources ( x86_64 ) >> and added the package RODBC >> and now I am trying to connect to a mysql database >> In windows R after installing the 3.51 driver >> and creating the dsn by specifying server, user, and password >> it is easy to connect with >> channel <- odbcConnect("dsn") >> >> Does anyone know what needs to be done to make this work from linux? > > Did you not read the RODBC README file? It is described in some detail > with reference to tutorials. > -- Bill Szkotnicki Department of Animal and Poultry Science University of Guelph [EMAIL PROTECTED] (519)824-4120 Ext 52253 ______________________________________________ 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.