jeff.lindon at thelearninginstitute.net
2007-Jul-26 13:39 UTC
[Rd] SQL server service pack 2 prob? (PR#9810)
Full_Name: Jeff Lindon Version: 2.5.0 OS: mingw32 Submission from: (NULL) (63.147.8.67) R 2.5.0 seems to be unable to read valid tables from SQL Server 2005 with Service Pack 2 installed:> version_ platform i386-pc-mingw32 arch i386 os mingw32 system i386, mingw32 status major 2 minor 5.0 year 2007 month 04 day 23 svn rev 41293 language R version.string R version 2.5.0 (2007-04-23)> library(RODBC) > channel <- odbcConnect("TLIAS01", uid="jeff.lindon") > channelRODB Connection 1 Details: case=nochange DSN=TLIAS01 UID=jeff.lindon Trusted_Connection=Yes WSID=TLIJLINDON DATABASE=tliresearch> d <- sqlFetch(channel, District)Error in odbcTableExists(channel, sqtable) : object "District" not found I have checked this problem with our CIO and he confirmed my Data Source configuration is correct (the connection test confirmed that R is able to connect to the database), and that the table really does exist and I have correct permissions (I work with it daily). Moreover, I was working between R and SQL Server 2005 with no problems before yesterday using the same exact set of instructions. The only change our CIO and I could think of is the recent installation of Service Pack 2. Unfortunately, reverting to Service Pack 1 is not currently an option, so I cannot be sure this is the problem. I am able to work around the issue by cutting and pasting the tables I need from SQL to Excel, then saving them as csv's. Saving directly from SQL to csv (highlighting the desired output and right-clicking) also causes problems for read.csv. I never tried that before Service Pack 2, though. I hope this information helps. I absolutely love R and thank you all so much for your work on it!
On Jul 26, 2007, at 9:39 AM, jeff.lindon at thelearninginstitute.net wrote:> Full_Name: Jeff Lindon > Version: 2.5.0 > OS: mingw32 > Submission from: (NULL) (63.147.8.67) > > > R 2.5.0 seems to be unable to read valid tables from SQL Server > 2005 with > Service Pack 2 installed: > >> version > _ > platform i386-pc-mingw32 > arch i386 > os mingw32 > system i386, mingw32 > status > major 2 > minor 5.0 > year 2007 > month 04 > day 23 > svn rev 41293 > language R > version.string R version 2.5.0 (2007-04-23) >> library(RODBC) >> channel <- odbcConnect("TLIAS01", uid="jeff.lindon") >> channel > RODB Connection 1 > Details: > case=nochange > DSN=TLIAS01 > UID=jeff.lindon > Trusted_Connection=Yes > WSID=TLIJLINDON > DATABASE=tliresearch >> d <- sqlFetch(channel, District) > Error in odbcTableExists(channel, sqtable) : > object "District" not found >Didn't you mean d <- sqlFetch(channel, "District") instead? Cheers, Simon PS: This is not an R bug, so please don't abuse the R bug tracking system for this. If at all, the question should go to R-help or the RODBC maintainer (please read the posting guide).> I have checked this problem with our CIO and he confirmed my Data > Source > configuration is correct (the connection test confirmed that R is > able to > connect to the database), and that the table really does exist and > I have > correct permissions (I work with it daily). Moreover, I was working > between R > and SQL Server 2005 with no problems before yesterday using the > same exact set > of instructions. The only change our CIO and I could think of is > the recent > installation of Service Pack 2. > > Unfortunately, reverting to Service Pack 1 is not currently an > option, so I > cannot be sure this is the problem. I am able to work around the > issue by > cutting and pasting the tables I need from SQL to Excel, then > saving them as > csv's. Saving directly from SQL to csv (highlighting the desired > output and > right-clicking) also causes problems for read.csv. I never tried > that before > Service Pack 2, though. > > I hope this information helps. I absolutely love R and thank you > all so much for > your work on it! > > ______________________________________________ > R-devel at r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-devel > >