Displaying 1 result from an estimated 1 matches for "rdatabase".
Did you mean:
database
2009 May 21
1
Error in importing table from SQL to R
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 'CampaignDataLar...