Displaying 1 result from an estimated 1 matches for "newdatasql4".
Did you mean:
newdatasql1
2009 May 21
1
Error in importing table from SQL to R
...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"
[2] "42S02 208 [Microsoft][ODBC SQL Server Driv...