[R] Using ODBC/RODBC with DBI

From: Magnus Torfason <mtt2108_at_columbia.edu>
Date: Mon, 30 Jun 2008 08:57:34 -0400


Hi all, I would like the following code to work, but it doesn't:

library(DBI)
library(RODBC)
m <- dbDriver("RODBC") # Example for dbConnect(DBI), causes error m <- dbDriver("ODBC") # Example for DBIDriver-class(DBI), causes error

The errors are:
Error in do.call(as.character(drvName), list(...)) :   could not find function "RODBC"
(substitute "ODBC" for "RODBC" to get the second error)

I've successfully used RODBC without using the DBI interface, and I've successfully used the DBI interface with SQLite.

Am I doing something wrong here or is DBI simply not implemented for ODBC? The latter seems unlikely considering the wide use of ODBC, but you never know. I hope it's just me doing something wrong.

Best,
Magnus

        [[alternative HTML version deleted]]



R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. Received on Mon 30 Jun 2008 - 13:01:42 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 03 Jul 2008 - 11:31:01 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive