Displaying 1 result from an estimated 1 matches for "rpt_paradigm".
2009 Jul 15
1
Help with RODBC connection to multiple MS SQL Sever databases
...the contab<-sqlTables(con), it is only getting information from one of the databases.
library(RODBC)
dwparadigm<-odbcConnect(dsn="dwParadigm", uid = "XXXXX", pwd = "XXXXXX", case = "nochange", believeNRows = TRUE)
rptparadigm<-odbcConnect(dsn="Rpt_Paradigm", uid = "XXXXX", pwd = "XXXX", case = "nochange", believeNRows = TRUE)
wcrpt<-odbcConnect(dsn="WC_Reporting", uid = "XXXXX", pwd = "XXXXX", case = "nochange", believeNRows = TRUE)
con<-odbcConnect(dsn=c("dwParadig...