Displaying 1 result from an estimated 1 matches for "newdatasql1".
Did you mean:
newdatasql3
2009 May 21
1
Error in importing table from SQL to R
...ntify and let me
know where did i go wrong??? Thanks in anticipation :)
library(RODBC)
myconn <- odbcConnect("RDATABASE")
myconn
RODB Connection 6
Details:
case=nochange
DSN=RDATABASE
Description=Database for R
UID=Madana_Babu
WSID=IBLPN1B049040
Trusted_Connection=Yes
NEWDATASQL1 <- sqlFetch(myconne, CampaignDataLarge)
Error in odbcTableExists(channel, sqtable) :
object 'CampaignDataLarge' not found
NEWDATASQL2 <- sqlFetch(myconne, CampaignDataLarge, colnames = FALSE,
rownames = TRUE)
Error in odbcTableExists(channel, sqtable) :
object 'CampaignDataLa...