(1) Set a new entry in your system-dsn for your odbc data source.
library(RODBC)
channel <- odbcConnect("dsn_name","","")
sqlFetch(channel, "table_name", errors = TRUE, as.is = FALSE, as =
"data frame",
colnames = FALSE, rownames = FALSE, nullstring = "NA",
na.strings = "NA")
....perhaps there are more appropriate functions for you ?
Try
help(RODBC)
regards,Christian
Lingyun Shi schrieb:
Hi,
Does anyone know how to call stored procedure from RODBC? Thanks.
Lingyun
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._