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]]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
