Displaying 1 result from an estimated 1 matches for "dwparadigm".
2009 Jul 15
1
Help with RODBC connection to multiple MS SQL Sever databases
...[2] "42000 102 [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'Completed'."
When I look at the tables from 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 = TRU...