[R] Summary: SQL-Interface

Jens Oehlschlägel-Akiyoshi jens.oehlschlaegel-akiyoshi at mdfactory.de
Mon Oct 25 20:09:57 CEST 1999

Some days ago I asked for general methods to access SQL-Databases.

Thanks to:
Terry Westley [twestley at buffalo.veridian.com], partha_bagchi at hgsi.com,
F.Tusell [etptupaf at bs.ehu.es], Michael Lapsley [mlapsley at ndirect.co.uk],
Robert Gentleman [rgentlem at jimmy.harvard.edu], Torsten Hothorn
[hothorn at statistik.uni-dortmund.de]

Several solutions were suggested:

(1) using Michael Lapsley's ODBC interface
    which seems now available for Unix,
    see www.ndirect.co.uk/~mlapsley as RODBC-0.1a.[tgz | zip]
    BTW, does anyone plan to port it to Windows?

(2) using ANSI dynamic SQL and the .C-Interface
    (and a proprietary pre-compiler, as I understand)
     see e.g. http://dan.emsphone.com/oracle/server.815/a68022/sqlansi.htm
     or http://www.cs.yorku.ca/~seela/db2/db2u0/db2u010.htm#HDRCOMPSQL

(3) directly using proprietary C-functions with the .C-Interface

(4) waiting for the .Java interface and using JDBC

(5) use the contributed package RmSQL from CRAN to access the freely
available mSQL
    (close to commercial MySQL)

(6) use an intermediate "glue" language such as Tcl (see
    which is expected to work for Oracle (oratcl) and Sybase,
    but not for DB2 or MS-SQL-Server

Sorry, I haven't found the time yet to implement any of those, so I can't
give recommendations.

Best regards

Dr. Jens Oehlschlägel-Akiyoshi
Bayerstrasse 21

80335 München

Tel.: 089 545 28-27
Fax.: 089 545 28-10

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

More information about the R-help mailing list