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
http://www.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
http://www.mdfactory.de
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Summary: SQL-Interface
2 messages · Jens Oehlschlägel-Akiyoshi, Michael Lapsley
On 25-Oct-99 Jens Oehlschlägel-Akiyoshi wrote:
(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?
Prof Ripley has helped me with making the code win compatable. (it does not really need porting as such, as that is the whole point of ODBC. It just has to be able to recognise the appropriate headers etc for the different compiler environments.) He has been able to compile it but has not yet tested the dll. Assuming it works, I'll be tidying up and releasing it hopefully on CRAN.
(5) use the contributed package RmSQL from CRAN to access the freely
available mSQL
(close to commercial MySQL)
FYI: mSQL is more commercial than MySQL as far as I know: the only thing you cannot do with MySQL is sell it. Michael ---------------------------------- E-Mail: Michael Lapsley <mlapsley at ndirect.co.uk> Date: 25-Oct-99 Time: 22:43:52 This message was sent by XFMail ---------------------------------- -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- 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 _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._