Displaying 1 result from an estimated 1 matches for "newdatasql3".
Did you mean:
newdatasql1
2009 May 21
1
Error in importing table from SQL to R
...nne, CampaignDataLarge)
Error in odbcTableExists(channel, sqtable) :
object 'CampaignDataLarge' not found
NEWDATASQL2 <- sqlFetch(myconne, CampaignDataLarge, colnames = FALSE,
rownames = TRUE)
Error in odbcTableExists(channel, sqtable) :
object 'CampaignDataLarge' not found
NEWDATASQL3 <- sqlFetchMore(myconne, CampaignDataLarge, colnames = TRUE,
rownames = TRUE)
NEWDATASQL3
[1] -1
NEWDATASQL4 <- sqlQuery(myconne, "select * from CampaignDataLarge", errors =
TRUE, colnames = FALSE, rownames = TRUE)
NEWDATASQL4
[1] "[RODBC] ERROR: Could not SQLExecDirect&qu...