Firstly can I add my congradulations to the R core team on the release of v1.0.0 and my thanks for all their hard work. To the subject of this message: does anyone have a binary version of Michael Lapsley's RODBC package built for win32 that they can distribute? I have a solution where I can use Perl ODBC functions to dump data to a text file for reading in to R, but I think the direct ODBC call from R would be a cleaner way of working. Thanks David Middleton dajm at deeq.demon.co.uk -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Bonjour, Je me joins ? tous pour vous f?licit? pour votre excellent travail. Bravo! Most sincere congratulations. I don't have RODBC but I may have something of interest. It's an ActiveX component (DLL) that I use for data access on any ODBC compliant Database. The problem I can see is that there is no way AFAIK to use it from a R script but it can be used from application that are ActiveX aware. May be I could work with others to find a solution to that? Regards. Yves ----- Original Message ----- From: "David Middleton" <dajm at deeq.demon.co.uk> To: <r-help at stat.math.ethz.ch> Sent: Tuesday, February 29, 2000 6:35 PM Subject: [R] RODBC> > Firstly can I add my congradulations to the R core team on the release > of v1.0.0 and my thanks for all their hard work. > > To the subject of this message: does anyone have a binary version of > Michael Lapsley's RODBC package built for win32 that they can > distribute? I have a solution where I can use Perl ODBC functions to > dump data to a text file for reading in to R, but I think the direct ODBC > call from R would be a cleaner way of working. > > Thanks > > David Middleton > dajm at deeq.demon.co.uk > -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-> r-help mailing list -- Readhttp://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html> Send "info", "help", or "[un]subscribe" > (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch >_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._. _._>-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
> From: "Yves Gauvreau" <cyg at sympatico.ca> > Date: Wed, 1 Mar 2000 08:28:23 -0500 > > I don't have RODBC but I may have something of interest. It's an ActiveX > component (DLL) that I use for data access on any ODBC compliant Database. > The problem I can see is that there is no way AFAIK to use it from a R > script but it can be used from application that are ActiveX aware. May be I > could work with others to find a solution to that? > > Regards. > > YvesI have sent David a compiled but untested version of RODBC for Windows. I don't have any ODBC sources on my laptop, but if anyone wants to test it, I will put it at http://www.stats.ox.ac.uk/pub/bdr/RODBC.zip. (If it does not work as is, would you try copying the DLL in libs.VC to libs and trying again? And in any case, please let me know.) Now, to use your ActiveX component, I think you will need a `glue' DLL to link it into R, as R itself is ActiveX deaf. This is the sort of thing that is probably very easy for experienced Windows programmers, so help would be very welcome. -- 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 272860 (secr) Oxford OX1 3TG, UK Fax: +44 1865 272595 -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-help-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._