[R] DBM databases for R?

Andrew Perrin andrew_perrin at unc.edu
Mon Jan 28 14:50:44 CET 2002


Unfortunately, I don't think that's what the OP is looking for - by DBM
databases she probably means Berkeley-style database files, for which (as
far as I know) there is no ODBC driver.  The only method I can think of to
do it would be to read the dbm using perl, then write it out, either to a
socket connected to R (the fancy way) or to a file which R could then read
in.

ap

----------------------------------------------------------------------
Andrew J Perrin - andrew_perrin at unc.edu - http://www.unc.edu/~aperrin
 Assistant Professor of Sociology, U of North Carolina, Chapel Hill
      269 Hamilton Hall, CB#3210, Chapel Hill, NC 27599-3210 USA


On Mon, 28 Jan 2002 Jan_Svatos at eurotel.cz wrote:

> 
> Hello,
> in general, there is RODBC package for general ODBC connection.
> This works for me well (Windows NT, with name.of.server in ODBC sources):
> 
> library(RODBC)
> str1 <- "some.sql.select"
> 
> channel <- odbcConnect("name.of.database","","",host="name.of.server") #
> connects to database
> BTS <- sqlQuery(channel, str1) # runs SQL command
> odbcClose(channel)
> 
> I think there are even some packages for specific RDBMS, like Postgres, but
> I am quite happy with RODBC
> 
> Jan
> 
> 
> 
> - - - Original message: - - -
> From: owner-r-help at stat.math.ethz.ch
> Send: 27/01/2002 3:35:33 PM
> To: <r-help at lists.r-project.org> "Petra Steiner" <steinep at uni-muenster.de>
> Subject: [R] DBM databases for R?
> 
> Hello!
> 
> Can I use DBM databases (as they are used in Perl) for the import of
> large datasets in R?
> 
> Thanks in advance for your help,
> 
> Petra Steiner
> 
> -
> ---------------------------------------------------
> Petra Steiner
> Arbeitsbereich Linguistik
> Universitaet Muenster
> Huefferstrasse 27
> 48149  Muenster
> 
> Tel: 0251 / 83 39442
> petra at marley.uni-muenster.de
> http://santana.uni-muenster.de/~petra/
> 
> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.
> -.-.-
> 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
> _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._.
> _._._
> 
> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
> 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
> _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
> 

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