Hi Friends,
I am trying to import a table from SQL server to R(2.9.0), however i am
getting errors while running the below codes. Can anyone identify 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 '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 Driver][SQL Server]Invalid object
name 'CampaignDataLarge'."
Regards,
Madan
--
View this message in context:
http://www.nabble.com/Error-in-importing-table-from-SQL-to-R-tp23650489p23650489.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
