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
>
>