[R] Rdbi and ODBC

[Uwe Ligges]

roger bos wrote:

> I have been using RODBC for a while with no complaints (R 2.0.1
> patched under WinXP), then I saw a link
> (http://grass.itc.it/statsgrass/r_and_dbms.html) showing that Rdbi
> claims to run a query in 5 seconds that takes RODBC 4.3 minutes.  That
> was hard enough for me to believe that I wanted to try some tests
> myself, but I cannot get Rdbi to connect to my ODBC database.
> 
> Here is what works for RODBC for my setup:
> conn <- odbcConnect("xf", "xfl2", "xfl2")
> 
> Now for Rdbi the documentation is lacking.  "?Rdbi" doesn't work and
> "?dbConnect" gives little detail and no examples.
> 
> I tried all of the following without success:
> conn <- dbConnect("ODBC()", dbname="xf", user="xfl2", password="xfl2")
> conn <- dbConnect("ODBC", dbname="xf", user="xfl2", password="xfl2")
> conn <- dbConnect(ODBC, dbname="xf", user="xfl2", password="xfl2")
> conn <- dbConnect(ODBC(), dbname="xf", user="xfl2", password="xfl2")
> 
> Also, if this package is so fast, how come its not available on CRAN?


Rdbi is a Bioconductor packge.

Uwe Ligges


> If I may ask a second question for my enlightenment.  It seems that
> PostgreSQL and mySQL are pretty popular, but my database is in SQL
> Server and I do not have the ability to change it.  How come every
> package has native drivers to PostreSQL and Oracle but none of them
> seem to have a native drive to SQL Server and I have to use ODBC?
> 
> Thanks in advance for any advice.
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html