R help - Oct 1999 - Summary: SQL-Interface

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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._

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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._