Dear R-fans, My database access package RODBC is now available on CRAN. For those who have never used it, odbc is a database and platform independant API which provides an SQL interface to a large number of database engines. The databases supported include not only SQL based RDBMS but also CSV files, foxbase, dBase, MSExcel etc. ODBC has been promoted mainly by Microsoft and this is where the driver support is most widespread and solid. Unix support is available (free) for some of the more common database engines. To my knowledge RODBC works with oracle, MSAccess, Sybase, DB2 and SQLServer on MSWindows platforms, and with MySQL, postgreSQL and oracle (with a slightly buggy beta driver) under unix. With access to the server I have been able to use it with MSAccess from unix as well by installing (free) bridging software. SQL itself is very easy to learn and use in the context of selecting data from a single table; a rather contrived search will look like 'SELECT col1,col2,col3 from MYTABLE where col1 > 999 and col2 = 'exact match' and col3 like '%wildcard match%' There are a number of convenience functions in the package to wrap up some of the more common usages of saving and retrieving dataframes. Please keep me posted with bug reports and suggestions. Michael -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-announce 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-announce-request at stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
On 24-May-00 Michael Lapsley wrote:> > Dear R-fans, > > My database access package RODBC is now available on CRAN. > [snip] > To my knowledge RODBC works with oracle, MSAccess, Sybase, > DB2 and SQLServer on MSWindows platforms, and with > MySQL, postgreSQL and oracle (with a slightly buggy > beta driver) under unix. With access to the server I > have been able to use it with MSAccess from unix as well by > installing (free) bridging software.As far as you can tell, could it also be put to work straightforwardly with Borland''s Interbase? (In my experience one of the nicest SQL engines available for Linux and currently available free). With thanks, Ted. -------------------------------------------------------------------- E-Mail: (Ted Harding) <Ted.Harding at nessie.mcc.ac.uk> Date: 24-May-00 Time: 15:05:29 ------------------------------ 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 _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
On Wed, May 24, 2000 at 03:05:30PM +0100, Ted Harding wrote:> > As far as you can tell, could it also be put to work straightforwardly > with Borland''s Interbase? (In my experience one of the nicest > SQL engines available for Linux and currently available free). > > With thanks, > Ted.Ted, I think you are probably out of luck here: I do not think there is a unix driver available for it. Michael -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- 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 _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._