From simon.urbanek at r-project.org  Thu Jul 26 18:07:40 2007
From: simon.urbanek at r-project.org (Simon Urbanek)
Date: Thu, 26 Jul 2007 12:07:40 -0400
Subject: [Rd] SQL server service pack 2 prob? (PR#9810)
In-Reply-To: <20070726133942.9E750667E2@slim.kubism.ku.dk>
References: <20070726133942.9E750667E2@slim.kubism.ku.dk>
Message-ID: <C468FBEE-1F5B-4737-97AA-EEABD3CE1086@r-project.org>


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



[Rd] SQL server service pack 2 prob? (PR#9810)
Simon Urbanek