Greetings guRus -- 

 

I have successfully queried a large (24,445 rows by 281 cols.) in-house
database using the following RODBC query (without the line breaks)

 

testout <- sqlQuery(channel, "select idSchedule,EXCL_Total from
dbo.vwC1198_2006_RawData_With_CMPL_EXCL")

 

This returns a dataframe of 24445 rows and two columns (as intended),
but the following command

 

testout <-
sqlFetch(channel,"dbo.vwC1198_2006_RawData_With_CMPL_EXCL",colnames =
TRUE,rownames = "idSchedule")

 

returns the error message 

 

in odbcTableExists(channel, sqtable) : 

        'dbo.vwC1198_2006_RawData_With_CMPL_EXCL': table not found on
channel

 

The value of channel did not change between the two commands.

 

Based on the help files for sqlFetch and sqlQuery, it is not clear to me
why one command would find the table and the other would not.  I am
running R 2.4.1 on a Windows XP pro machine with 2 gig of memory.

 

Thanks for any suggestions or hints,

 

Ben Fairbank

 


	[[alternative HTML version deleted]]

