[R] DBM databases for R?

Jan_Svatos@eurotel.cz Jan_Svatos at eurotel.cz
Mon Jan 28 09:23:04 CET 2002


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



More information about the R-help mailing list