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 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. dan.emsphone.com/oracle/server.815/a68022/sqlansi.htm
or 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
scriptics.com),
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
MD FACTORY GmbH
Bayerstrasse 21
80335 M?nchen
Tel.: 089 545 28-27
Fax.: 089 545 28-10
mdfactory.de
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read 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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._