Re: [Rd] SQL server service pack 2 prob? (PR#9810)

From: Simon Urbanek <simon.urbanek_at_r-project.org>
Date: Thu, 26 Jul 2007 12:07:40 -0400

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



R-devel_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-devel Received on Thu 26 Jul 2007 - 16:12:23 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 26 Jul 2007 - 18:36:48 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-devel. Please read the posting guide before posting to the list.